Skip to content

Instantly share code, notes, and snippets.

@ehlyzov

ehlyzov/grep_by_okved_postcode.sparql

Last active November 19, 2017 12:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ehlyzov/4fd3ff11bd516b61719d3eedb7b7ed3d to your computer and use it in GitHub Desktop.
Save ehlyzov/4fd3ff11bd516b61719d3eedb7b7ed3d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
grep_by_okved_postcode.sparql
PREFIX fts: <https://w3id.org/datafabric.cc/ontologies/fts#>
SELECT ?ogrn ?primaryCode ?fullname WHERE {
?leUri a fts:C101_Russian_Legal_Entity .
?addressE a fts:C39_Address_Entity ;
fts:p82_refers_to_company ?leUri ;
fts:isLatestEntity "true"^^xsd:boolean ;
fts:p18_postcode "193231" .
?leUri fts:p28_le_primary_state_registration_number ?ogrn .
?nameE a fts:C38_Name_Entity ;
fts:p82_refers_to_company ?leUri ;
fts:isLatestEntity "true"^^xsd:boolean ;
fts:p16_full_name ?fullname .
?okvedE a fts:C57_LE_Activity_Entity ;
fts:p82_refers_to_company ?leUri ;
fts:isLatestEntity "true"^^xsd:boolean ;
fts:p107_is_main_activity/fts:p5_code ?primaryCode ;
fts:p107_is_main_activity/fts:p26_version "2014" .
FILTER ( ?primaryCode = "46.43.1")
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment