TERYT_gminy.xsd 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
  3. xmlns:hfp="http://www.w3.org/2001/XMLSchema-hasFacetAndProperty"
  4. xmlns:default_db__x3A__TERYT_SIMC="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_SIMC.xsd"
  5. xmlns:default_db__x3A__TERYT_powiaty="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_powiaty.xsd"
  6. xmlns:default_db__x3A__TERYT_gminy="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_gminy.xsd"
  7. xmlns:default_db__x3A__TERYT_wojewodztwa="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_wojewodztwa.xsd"
  8. xmlns:ogc="http://www.opengis.net/ogc"
  9. xmlns:fes="http://www.opengis.net/fes/2.0"
  10. xmlns:default_db__x3A__TERYT_ulice="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_ulice.xsd"
  11. xmlns:default_db__x3A__TERYT_adresy="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_adresy.xsd"
  12. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  13. xmlns:p5_tr_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"
  14. xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning"
  15. xmlns:system_cache__resources_tree_generate_xsl_required_occurs_raport="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/resources_tree_generate_xsl_require_occurs_raport"
  16. xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
  17. xmlns:p5opr="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/object_parent_relations/object_parent_relations.xsd"
  18. xmlns:p5_simpleSchema_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_simpleSchema_map.xsd"
  19. xmlns:ant-object="http://biuro.biall-net.pl/xmlschema_procesy5/ant-object/ant-object.xsd"
  20. xmlns:p5ant-interface="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/ant_interface/ant_interface.xsd"
  21. targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_gminy.xsd"
  22. vc:minVersion="1.1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  23. <xs:annotation>
  24. <xs:documentation>CREATE ALGORITHM=UNDEFINED DEFINER=`bzyk`@`94.158.130.34` SQL SECURITY DEFINER VIEW `TERYT_gminy`
  25. AS SELECT
  26. ((((`TERYT_TERC`.`WOJ` * 16777216) + (`TERYT_TERC`.`POW` * 65536)) + (`TERYT_TERC`.`GMI` * 256)) + `TERYT_TERC`.`RODZ`) AS `ID`,
  27. `TERYT_TERC`.`WOJ` AS `ID_TERYT_wojewodztwa`,((`TERYT_TERC`.`WOJ` * 256) + `TERYT_TERC`.`POW`) AS `ID_TERYT_powiaty`,
  28. `TERYT_TERC`.`WOJ` AS `WOJ`,
  29. `TERYT_TERC`.`POW` AS `POW`,
  30. `TERYT_TERC`.`GMI` AS `GMI`,
  31. `TERYT_TERC`.`RODZ` AS `RODZ`,
  32. `TERYT_TERC`.`NAZWA` AS `NAZWA`,
  33. `TERYT_TERC`.`NAZWA_DOD` AS `NAZWA_DOD`
  34. FROM `TERYT_TERC` where (`TERYT_TERC`.`GMI` is not null);</xs:documentation>
  35. </xs:annotation>
  36. <xs:import schemaLocation="../../default_db.TERYT_adresy/TERYT_adresy/TERYT_adresy.xsd"
  37. namespace="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_adresy.xsd"/>
  38. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_ulice.xsd"
  39. schemaLocation="../../default_db.TERYT_ulice/TERYT_ulice/TERYT_ulice.xsd"/>
  40. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_powiaty.xsd"
  41. schemaLocation="../../default_db.TERYT_powiaty/TERYT_powiaty/TERYT_powiaty.xsd"/>
  42. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_wojewodztwa.xsd"
  43. schemaLocation="../../default_db.TERYT_wojewodztwa/TERYT_wojewodztwa/TERYT_wojewodztwa.xsd"/>
  44. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_adresy.xsd"
  45. schemaLocation="../../default_db.TERYT_adresy/TERYT_adresy/TERYT_adresy.xsd"/>
  46. <xs:complexType name="TERYT_gminy" id="TERYT_gminy___d18e20714-1_TERYT_gmin">
  47. <xs:sequence id="TERYT_gminy___d18e20715-1">
  48. <xs:element name="ID" type="xs:int" id="TERYT_gminy___d18e20716-1_ID"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  49. <xs:annotation>
  50. <xs:documentation>((((`TERYT_TERC`.`WOJ` * 16777216) + (`TERYT_TERC`.`POW` * 65536)) + (`TERYT_TERC`.`GMI` * 256)) + `TERYT_TERC`.`RODZ`) AS `ID`</xs:documentation>
  51. </xs:annotation>
  52. </xs:element>
  53. <xs:element name="ID_TERYT_wojewodztwa"
  54. type="xs:int"
  55. id="TERYT_gminy___d18e20720-1_ID_TERYT_w"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  56. <xs:annotation>
  57. <xs:documentation>To samo co WOJ
  58. `TERYT_TERC`.`WOJ` AS `ID_TERYT_wojewodztwa`</xs:documentation>
  59. </xs:annotation>
  60. </xs:element>
  61. <xs:element name="ID_TERYT_powiaty"
  62. type="xs:int"
  63. id="TERYT_gminy___d18e20724-1_ID_TERYT_p"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  64. <xs:annotation>
  65. <xs:documentation>((`TERYT_TERC`.`WOJ` * 256) + `TERYT_TERC`.`POW`) AS `ID_TERYT_powiaty`</xs:documentation>
  66. </xs:annotation>
  67. </xs:element>
  68. <xs:element name="WOJ" type="xs:int" id="TERYT_gminy___d18e20728-1_WOJ"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  69. <xs:annotation>
  70. <xs:documentation>`TERYT_TERC`.`WOJ` AS `WOJ`
  71. to samo co ID_TERYT_wojewodztwa</xs:documentation>
  72. </xs:annotation>
  73. </xs:element>
  74. <xs:element ref="default_db__x3A__TERYT_wojewodztwa:TERYT_wojewodztwa"
  75. id="TERYT_gminy___d18e20732-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  76. <xs:annotation>
  77. <xs:appinfo>
  78. <system_cache__appinfo:flat_relation_cache>
  79. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  80. system_cache__appinfo:name="ID_TERYT_wojewodztwa"
  81. system_cache__appinfo:xpath="default_db__x3A__TERYT_wojewodztwa:TERYT_wojewodztwa/ID"><!--<fes:Filter>
  82. <fes:PropertyIsEqualTo>
  83. <fes:ValueReference>WOJ</fes:ValueReference>
  84. <fes:ValueReference>default_db__x3A__TERYT_wojewodztwa:TERYT_wojewodztwa/WOJ</fes:ValueReference>
  85. </fes:PropertyIsEqualTo>
  86. </fes:Filter>--></system_cache__appinfo:source>
  87. </system_cache__appinfo:flat_relation_cache>
  88. </xs:appinfo>
  89. <xs:documentation>Zawsze moze wyskoczyc z wyszukiwania spowrotem na województwa</xs:documentation>
  90. </xs:annotation>
  91. </xs:element>
  92. <xs:element name="POW" type="xs:int" id="TERYT_gminy___d18e20740-1_POW"/>
  93. <xs:element ref="default_db__x3A__TERYT_powiaty:TERYT_powiaty"
  94. id="TERYT_gminy___d18e20741-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  95. <xs:annotation>
  96. <xs:appinfo>
  97. <system_cache__appinfo:flat_relation_cache>
  98. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  99. system_cache__appinfo:name="ID_TERYT_powiaty"
  100. system_cache__appinfo:xpath="default_db__x3A__TERYT_powiaty:TERYT_powiaty/ID"><!--<fes:Filter>
  101. <fes:And>
  102. <fes:PropertyIsEqualTo>
  103. <fes:ValueReference>WOJ</fes:ValueReference>
  104. <fes:ValueReference>default_db__x3A__TERYT_powiaty:TERYT_powiaty/WOJ</fes:ValueReference>
  105. </fes:PropertyIsEqualTo>
  106. <fes:PropertyIsEqualTo>
  107. <fes:ValueReference>POW</fes:ValueReference>
  108. <fes:ValueReference>default_db__x3A__TERYT_powiaty:TERYT_powiaty/POW</fes:ValueReference>
  109. </fes:PropertyIsEqualTo>
  110. </fes:And>
  111. </fes:Filter>--></system_cache__appinfo:source>
  112. </system_cache__appinfo:flat_relation_cache>
  113. </xs:appinfo>
  114. <xs:documentation>Zawsze moze wyskoczyc z wyszukiwania spowrotem na powiaty</xs:documentation>
  115. </xs:annotation>
  116. </xs:element>
  117. <xs:element name="GMI" type="xs:int" id="TERYT_gminy___d18e20749-1_GMI"/>
  118. <xs:element name="NAZWA" type="xs:string" id="TERYT_gminy___d18e20750-1_NAZWA"/>
  119. <!--<xs:element maxOccurs="unbounded" minOccurs="1"
  120. ref="default_db__x3A__TERYT_SIMC:TERYT_SIMC">
  121. <xs:annotation>
  122. <xs:documentation>Przejscue do przegladania miejscowosci z danej gminy</xs:documentation>
  123. </xs:annotation>
  124. </xs:element>-->
  125. <xs:element ref="default_db__x3A__TERYT_ulice:TERYT_ulice"
  126. maxOccurs="unbounded"
  127. minOccurs="0"
  128. id="TERYT_gminy___d18e20752-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  129. <xs:annotation>
  130. <xs:documentation>
  131. Variables are specified in WMS GetMap requests by using the env request parameter followed by a list of name:value pairs separated by semicolons:
  132. ...&amp;env=name1:value1;name2=value2&amp;...
  133. <!--<ogc:Function name="env">
  134. <ogc:Literal>size</ogc:Literal>
  135. </ogc:Function>--></xs:documentation>
  136. <xs:appinfo>
  137. <system_cache__appinfo:flat_relation_cache>
  138. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view">
  139. <fes:Filter>
  140. <fes:And>
  141. <fes:PropertyIsEqualTo>
  142. <fes:ValueReference>WOJ</fes:ValueReference>
  143. <fes:ValueReference>default_db__x3A__TERYT_ulice:TERYT_ulice/WOJ</fes:ValueReference>
  144. </fes:PropertyIsEqualTo>
  145. <fes:PropertyIsEqualTo>
  146. <fes:ValueReference>POW</fes:ValueReference>
  147. <fes:ValueReference>default_db__x3A__TERYT_ulice:TERYT_ulice/POW</fes:ValueReference>
  148. </fes:PropertyIsEqualTo>
  149. <fes:PropertyIsEqualTo>
  150. <fes:ValueReference>GMI</fes:ValueReference>
  151. <fes:ValueReference>default_db__x3A__TERYT_ulice:TERYT_ulice/GMI</fes:ValueReference>
  152. </fes:PropertyIsEqualTo>
  153. </fes:And>
  154. </fes:Filter>
  155. <!--<ogc:Filter>
  156. <ogc:And>
  157. <ogc:PropertyIsEqualTo><ogc:PropertyName>ID</ogc:PropertyName><ogc:Literal>2</ogc:Literal></ogc:PropertyIsEqualTo>
  158. </ogc:And>
  159. </ogc:Filter>-->
  160. </system_cache__appinfo:source>
  161. </system_cache__appinfo:flat_relation_cache>
  162. </xs:appinfo>
  163. </xs:annotation>
  164. </xs:element>
  165. <xs:element maxOccurs="unbounded"
  166. minOccurs="0"
  167. ref="default_db__x3A__TERYT_adresy:TERYT_adresy"
  168. id="TERYT_gminy___d18e20779-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  169. <xs:annotation>
  170. <xs:appinfo>
  171. <system_cache__appinfo:flat_relation_cache>
  172. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view">
  173. <fes:Filter>
  174. <fes:PropertyIsEqualTo><!-- joinuje przez ulice -->
  175. <fes:ValueReference>WOJ</fes:ValueReference>
  176. <fes:ValueReference>default_db__x3A__TERYT_ulice:TERYT_ulice/WOJ</fes:ValueReference>
  177. </fes:PropertyIsEqualTo>
  178. <fes:PropertyIsEqualTo>
  179. <fes:ValueReference>POW</fes:ValueReference>
  180. <fes:ValueReference>default_db__x3A__TERYT_ulice:TERYT_ulice/POW</fes:ValueReference>
  181. </fes:PropertyIsEqualTo>
  182. <fes:PropertyIsEqualTo>
  183. <fes:ValueReference>GMI</fes:ValueReference>
  184. <fes:ValueReference>default_db__x3A__TERYT_ulice:TERYT_ulice/GMI</fes:ValueReference>
  185. </fes:PropertyIsEqualTo>
  186. <fes:PropertyIsEqualTo>
  187. <fes:ValueReference>default_db__x3A__TERYT_ulice:TERYT_ulice/SYM</fes:ValueReference>
  188. <fes:ValueReference>default_db__x3A__TERYT_adresy:TERYT_adresy/TERYT_SYM</fes:ValueReference>
  189. </fes:PropertyIsEqualTo>
  190. </fes:Filter>
  191. <!--<fes:Filter><!-\- chyba jest to potrzebne, eby wykluczyc niepotrzebne wyniki -\->
  192. <fes:PropertyIsEqualTo>
  193. <fes:ValueReference>default_db__x3A__TERYT_adresy:TERYT_adresy/TERYT_SYM</fes:ValueReference>
  194. <fes:ValueReference>default_db__x3A__TERYT_adresy:TERYT_adresy/TERYT_SYM</fes:ValueReference>
  195. </fes:PropertyIsEqualTo>
  196. </fes:Filter>-->
  197. </system_cache__appinfo:source>
  198. <!--<system_cache__appinfo:TYPESPECIAL>
  199. <system_cache__appinfo:PARAM_OUT>
  200. <system_cache__appinfo:ALIAS_ID>
  201. <fes:ValueReference>default_db__x3A__TERYT_adresy:TERYT_adresy/default_db__x3A__TERYT_ulice:TERYT_ulice/SYM_UL</fes:ValueReference>
  202. </system_cache__appinfo:ALIAS_ID>
  203. <system_cache__appinfo:DESC>
  204. <fes:ValueReference>default_db__x3A__TERYT_adresy:TERYT_adresy/default_db__x3A__TERYT_ulice:TERYT_ulice/NAZWA_1</fes:ValueReference>
  205. </system_cache__appinfo:DESC>
  206. <system_cache__appinfo:DESC>
  207. <fes:ValueReference>default_db__x3A__TERYT_adresy:TERYT_adresy/default_db__x3A__TERYT_ulice:TERYT_ulice/NAZWA_2</fes:ValueReference>
  208. </system_cache__appinfo:DESC>
  209. <!-\- chyba nie ma sensu tutaj klikac -\->
  210. <system_cache__appinfo:PARAM_IN>
  211. <!-\- tutaj nalezy zapisać wyszukaną ulicę -\->
  212. <fes:ValueReference>default_db__x3A__TERYT_adresy:TERYT_adresy/TERYT_SYM_UL</fes:ValueReference>
  213. </system_cache__appinfo:PARAM_IN>
  214. </system_cache__appinfo:PARAM_OUT>
  215. <!-\-<system_cache__appinfo:PARAM_EXPORT>
  216. <system_cache__appinfo:ALIAS_ID>
  217. <fes:ValueReference>default_db__x3A__TERYT_adresy:TERYT_adresy/TERYT_SYM_UL</fes:ValueReference>
  218. </system_cache__appinfo:ALIAS_ID>
  219. <system_cache__appinfo:DESC>
  220. <fes:ValueReference>SYM_UL</fes:ValueReference>
  221. </system_cache__appinfo:DESC>
  222. </system_cache__appinfo:PARAM_EXPORT>-\->
  223. </system_cache__appinfo:TYPESPECIAL>-->
  224. </system_cache__appinfo:flat_relation_cache>
  225. </xs:appinfo>
  226. <xs:documentation>Wyszukiwanie adresow bedzie tez mozliwe z tego kontekstu.</xs:documentation>
  227. </xs:annotation>
  228. </xs:element>
  229. </xs:sequence>
  230. <xs:attribute name="label" type="xs:string" id="TERYT_gminy___d18e20810-1_label"/>
  231. <xs:assert test="@label = concat(NAZWA, ' ', default_db__x3A__TERYT_powiaty:TERYT_powiaty/@label, ' ', default_db__x3A__TERYT_wojewodztwa:TERYT_wojewodztwa/@label)"
  232. id="TERYT_gminy___d18e20811-1"/>
  233. <xs:assert test="WOJ = default_db__x3A__TERYT_ulice:TERYT_ulice/WOJ"
  234. id="TERYT_gminy___d18e20812-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  235. <xs:annotation>
  236. <xs:documentation>Szukamy dla tego samego wojewodztwa
  237. (dodatk. zabezp sa na flat_rel_cache)</xs:documentation>
  238. </xs:annotation>
  239. </xs:assert>
  240. <xs:assert test="POW = default_db__x3A__TERYT_ulice:TERYT_ulice/POW"
  241. id="TERYT_gminy___d18e20816-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  242. <xs:annotation>
  243. <xs:documentation>taki sam powiat dla szukania</xs:documentation>
  244. </xs:annotation>
  245. </xs:assert>
  246. <xs:assert test="GMI = default_db__x3A__TERYT_ulice:TERYT_ulice/GMI"
  247. id="TERYT_gminy___d18e20820-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  248. <xs:annotation>
  249. <xs:documentation>Tylko ulicy z danej gminy w kontekscie szukania</xs:documentation>
  250. </xs:annotation>
  251. </xs:assert>
  252. </xs:complexType>
  253. <xs:element name="TERYT_gminy"
  254. type="default_db__x3A__TERYT_gminy:TERYT_gminy"
  255. id="TERYT_gminy___d18e20824-1_TERYT_gmin"/>
  256. </xs:schema>