trees

Custom SQL query returning 71 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
3873 19441 1 260 1300X Sloat Blvd 2 Median : Cutout Tree 1     3 20   5986928.6035 2095895.7656 37.7341762495639 -122.487622811763 (37.7341762495639, -122.487622811763) 1 8 4 64 35
4001 19476 1 260 1900X Sloat Blvd 3 Median : Cutout Tree 1     3 20   5984946.1404685 2095883.2432037 37.734026040705 -122.494475789917 (37.734026040705, -122.494475789917) 1 8 3 29491 35
10769 19433 1 260 1300X Sloat Blvd 1 Median : Cutout Tree 1     6 20   5987408.7322245 2095946.646093 37.7343439457369 -122.485966609595 (37.7343439457369, -122.485966609595) 1 8 3 64 35
11301 19470 1 260 1800X Sloat Blvd 4 Median : Cutout Tree 1     6 20   5985262.7171661 2095894.5517007 37.7340756136127 -122.493382135065 (37.7340756136127, -122.493382135065) 1 8 3 29491 35
13853 19419 1 260 800X Sloat Blvd 3 Median : Cutout Tree 1     6 20   5988998.1028282 2096024.0271709 37.7346489082814 -122.480477366023 (37.7346489082814, -122.480477366023) 1 8 3 64 35
14602 19390 1 260 100X Sloat Blvd 6 Median : Cutout Tree 1     6 20   5991082.2835044 2096052.6376293 37.7348483670999 -122.473273805701 (37.7348483670999, -122.473273805701) 1 8 4 29491 40
17987 19440 1 260 1300X Sloat Blvd 3 Median : Cutout Tree 1     3 20   5987401.6755259 2095951.2124587 37.7343560725457 -122.485991341651 (37.7343560725457, -122.485991341651) 1 8 3 64 35
23385 19480 1 260 1900X Sloat Blvd 7 Median : Cutout Tree 1     3 20   5984946.1404685 2095883.2432037 37.734026040705 -122.494475789917 (37.734026040705, -122.494475789917) 1 8 3 29491 35
24157 19445 1 260 1400X Sloat Blvd 2 Median : Cutout Tree 1     6 20   5986974.9102614 2095954.0242956 37.7343389133904 -122.48746699486 (37.7343389133904, -122.48746699486) 1 8 3 64 35
26657 19389 1 260 100X Sloat Blvd 5 Median : Cutout Tree 1     24 20   5991082.2835044 2096052.6376293 37.7348483670999 -122.473273805701 (37.7348483670999, -122.473273805701) 1 8 4 29491 40
27675 19466 1 260 1700X Sloat Blvd 12 Median : Cutout Tree 1     6 20   5985858.9484667 2095882.6709765 37.7340778499573 -122.491319932369 (37.7340778499573, -122.491319932369) 1 8 3 64 35
29988 19481 1 260 1900X Sloat Blvd 8 Median : Cutout Tree 1     3 20   5984946.1404685 2095883.2432037 37.734026040705 -122.494475789917 (37.734026040705, -122.494475789917) 1 8 3 29491 35
32656 19454 1 260 1500X Sloat Blvd 5 Median : Cutout Tree 1     6 20   5986548.4544357 2095908.9031645 37.7341901424899 -122.488938055092 (37.7341901424899, -122.488938055092) 1 8 3 64 35
35771 19442 1 260 1302X Sloat Blvd 5 Median : Cutout Tree 1     6 20   5987401.6755259 2095951.2124587 37.7343560725457 -122.485991341651 (37.7343560725457, -122.485991341651) 1 8 3 64 35
37493 19469 1 260 1800X Sloat Blvd 3 Median : Cutout Tree 1     12 20   5985262.7171661 2095894.5517007 37.7340756136127 -122.493382135065 (37.7340756136127, -122.493382135065) 1 8 3 29491 35
37987 19471 1 260 1800X Sloat Blvd 5 Median : Cutout Tree 1     6 20   5985262.7171661 2095894.5517007 37.7340756136127 -122.493382135065 (37.7340756136127, -122.493382135065) 1 8 3 29491 35
39124 19472 1 260 1800X Sloat Blvd 6 Median : Cutout Tree 1     3 20   5985262.7171661 2095894.5517007 37.7340756136127 -122.493382135065 (37.7340756136127, -122.493382135065) 1 8 3 29491 35
40171 19399 1 260 300X Sloat Blvd 3 Median : Cutout Tree 1     3 20   5990549.2944822 2096013.3169503 37.7347095261344 -122.475113645462 (37.7347095261344, -122.475113645462) 1 8 4 64 40
43817 19432 1 260 1300X Sloat Blvd 1 Median : Cutout Tree 1     6 20   5987408.7322245 2095946.646093 37.7343439457369 -122.485966609595 (37.7343439457369, -122.485966609595) 1 8 3 64 35
44349 19479 1 260 1900X Sloat Blvd 6 Median : Cutout Tree 1     3 20   5984946.1404685 2095883.2432037 37.734026040705 -122.494475789917 (37.734026040705, -122.494475789917) 1 8 3 29491 35
46243 19413 1 260 600X Sloat Blvd 4 Median : Cutout Tree 1     6 20   5989744.8312093 2096044.8028161 37.7347493206824 -122.477897219949 (37.7347493206824, -122.477897219949) 1 8 3 64 35
48572 19394 1 260 200X Sloat Blvd 3 Median : Cutout Tree 1     6 20   5990818.4331684 2096048.8602469 37.7348227139519 -122.474185743261 (37.7348227139519, -122.474185743261) 1 8 4 29491 40
52703 19426 1 260 1000X Sloat Blvd 3 Median : Cutout Tree 1     6 20   5988569.2838063 2095968.4634055 37.7344714144349 -122.481955851921 (37.7344714144349, -122.481955851921) 1 8 3 64 35
52986 19477 1 260 1900X Sloat Blvd 4 Median : Cutout Tree 1     3 20   5984946.1404685 2095883.2432037 37.734026040705 -122.494475789917 (37.734026040705, -122.494475789917) 1 8 3 29491 35
56574 19385 1 260 100X Sloat Blvd 1 Median : Cutout Tree 1     30 20   5991082.2835044 2096052.6376293 37.7348483670999 -122.473273805701 (37.7348483670999, -122.473273805701) 1 8 4 29491 40
64565 19392 1 260 200X Sloat Blvd 1 Median : Cutout Tree 1     6 20   5990818.4331684 2096048.8602469 37.7348227139519 -122.474185743261 (37.7348227139519, -122.474185743261) 1 8 4 29491 40
70025 19434 1 260 1300X Sloat Blvd 3 Median : Cutout Tree 1     6 20   5987408.7322245 2095946.646093 37.7343439457369 -122.485966609595 (37.7343439457369, -122.485966609595) 1 8 3 64 35
82228 19475 1 260 1900X Sloat Blvd 2 Median : Cutout Tree 1     6 20   5984946.1404685 2095883.2432037 37.734026040705 -122.494475789917 (37.734026040705, -122.494475789917) 1 8 3 29491 35
82548 19400 1 260 300X Sloat Blvd 4 Median : Cutout Tree 1     6 20   5990549.2944822 2096013.3169503 37.7347095261344 -122.475113645462 (37.7347095261344, -122.475113645462) 1 8 4 64 40
84775 19420 1 260 800X Sloat Blvd 4 Median : Cutout Tree 1     3 20   5988998.1028282 2096024.0271709 37.7346489082814 -122.480477366023 (37.7346489082814, -122.480477366023) 1 8 3 64 35
89237 19444 1 260 1400X Sloat Blvd 1 Median : Cutout Tree 1     6 20   5986974.9102614 2095954.0242956 37.7343389133904 -122.48746699486 (37.7343389133904, -122.48746699486) 1 8 3 64 35
93663 19452 1 260 1500X Sloat Blvd 3 Median : Cutout Tree 1     3 20   5986548.4544357 2095908.9031645 37.7341901424899 -122.488938055092 (37.7341901424899, -122.488938055092) 1 8 3 64 35
96543 19447 1 260 1400X Sloat Blvd 4 Median : Cutout Tree 1     3 20   5986974.9102614 2095954.0242956 37.7343389133904 -122.48746699486 (37.7343389133904, -122.48746699486) 1 8 3 64 35
98447 19467 1 260 1800X Sloat Blvd 1 Median : Cutout Tree 1     3 20   5985262.7171661 2095894.5517007 37.7340756136127 -122.493382135065 (37.7340756136127, -122.493382135065) 1 8 3 29491 35
102311 19412 1 260 600X Sloat Blvd 3 Median : Cutout Tree 1     30 20   5989744.8312093 2096044.8028161 37.7347493206824 -122.477897219949 (37.7347493206824, -122.477897219949) 1 8 3 64 35
102450 19482 1 260 1900X Sloat Blvd 9 Median : Cutout Tree 1     3 20   5984946.1404685 2095883.2432037 37.734026040705 -122.494475789917 (37.734026040705, -122.494475789917) 1 8 3 29491 35
102917 19411 1 260 600X Sloat Blvd 2 Median : Cutout Tree 1     6 20   5989744.8312093 2096044.8028161 37.7347493206824 -122.477897219949 (37.7347493206824, -122.477897219949) 1 8 3 64 35
112135 19408 1 260 500X Sloat Blvd 5 Median : Cutout Tree 1     24 20   5989983.811155 2096024.6780472 37.7347079305354 -122.477069523101 (37.7347079305354, -122.477069523101) 1 8 3 64 35
114683 19478 1 260 1900X Sloat Blvd 5 Median : Cutout Tree 1     3 20   5984946.1404685 2095883.2432037 37.734026040705 -122.494475789917 (37.734026040705, -122.494475789917) 1 8 3 29491 35
116967 19459 1 260 1700X Sloat Blvd 5 Median : Cutout Tree 1     6 20   5985858.9484667 2095882.6709765 37.7340778499573 -122.491319932369 (37.7340778499573, -122.491319932369) 1 8 3 64 35
117670 19409 1 260 500X Sloat Blvd 6 Median : Cutout Tree 1     6 20   5989983.811155 2096024.6780472 37.7347079305354 -122.477069523101 (37.7347079305354, -122.477069523101) 1 8 3 64 35
122494 19465 1 260 1700X Sloat Blvd 11 Median : Cutout Tree 1     6 20   5985858.9484667 2095882.6709765 37.7340778499573 -122.491319932369 (37.7340778499573, -122.491319932369) 1 8 3 64 35
129195 19468 1 260 1800X Sloat Blvd 2 Median : Cutout Tree 1     6 20   5985262.7171661 2095894.5517007 37.7340756136127 -122.493382135065 (37.7340756136127, -122.493382135065) 1 8 3 29491 35
145676 19414 1 260 600X Sloat Blvd 5 Median : Cutout Tree 1     24 20   5989744.8312093 2096044.8028161 37.7347493206824 -122.477897219949 (37.7347493206824, -122.477897219949) 1 8 3 64 35
151333 19393 1 260 200X Sloat Blvd 2 Median : Cutout Tree 1     3 20   5990818.4331684 2096048.8602469 37.7348227139519 -122.474185743261 (37.7348227139519, -122.474185743261) 1 8 4 29491 40
151605 19451 1 260 1500X Sloat Blvd 2 Median : Cutout Tree 1     24 20   5986548.4544357 2095908.9031645 37.7341901424899 -122.488938055092 (37.7341901424899, -122.488938055092) 1 8 3 64 35
157373 19473 1 260 1800X Sloat Blvd 7 Median : Cutout Tree 1     3 20   5985262.7171661 2095894.5517007 37.7340756136127 -122.493382135065 (37.7340756136127, -122.493382135065) 1 8 3 29491 35
157511 19429 1 260 1200X Sloat Blvd 2 Median : Cutout Tree 1     24 20   5987947.5018995 2095985.7700738 37.7344827526385 -122.484106799366 (37.7344827526385, -122.484106799366) 1 8 3 64 35
157531 19425 1 260 1000X Sloat Blvd 2 Median : Cutout Tree 1     6 20   5988569.2838063 2095968.4634055 37.7344714144349 -122.481955851921 (37.7344714144349, -122.481955851921) 1 8 3 64 35
157785 19427 1 260 1000X Sloat Blvd 4 Median : Cutout Tree 1     6 20   5988569.2838063 2095968.4634055 37.7344714144349 -122.481955851921 (37.7344714144349, -122.481955851921) 1 8 3 64 35
158753 19422 1 260 840X Sloat Blvd 1 Median : Cutout Tree 1     6 20   5988998.1028282 2096024.0271709 37.7346489082814 -122.480477366023 (37.7346489082814, -122.480477366023) 1 8 3 64 35
160145 19386 1 260 100X Sloat Blvd 2 Median : Cutout Tree 1     6 20   5991082.2835044 2096052.6376293 37.7348483670999 -122.473273805701 (37.7348483670999, -122.473273805701) 1 8 4 29491 40
164174 19463 1 260 1700X Sloat Blvd 9 Median : Cutout Tree 1     6 20   5985858.9484667 2095882.6709765 37.7340778499573 -122.491319932369 (37.7340778499573, -122.491319932369) 1 8 3 64 35
167249 19418 1 260 800X Sloat Blvd 2 Median : Cutout Tree 1     6 20   5988998.1028282 2096024.0271709 37.7346489082814 -122.480477366023 (37.7346489082814, -122.480477366023) 1 8 3 64 35
170087 19439 1 260 1302X Sloat Blvd 2 Median : Cutout Tree 1     18 20   5987401.6755259 2095951.2124587 37.7343560725457 -122.485991341651 (37.7343560725457, -122.485991341651) 1 8 3 64 35
173066 19406 1 260 500X Sloat Blvd 3 Median : Cutout Tree 1     24 20   5989983.811155 2096024.6780472 37.7347079305354 -122.477069523101 (37.7347079305354, -122.477069523101) 1 8 3 64 35
177565 19410 1 260 600X Sloat Blvd 1 Median : Cutout Tree 1     30 20   5989744.8312093 2096044.8028161 37.7347493206824 -122.477897219949 (37.7347493206824, -122.477897219949) 1 8 3 64 35
178103 19421 1 260 800X Sloat Blvd 5 Median : Cutout Tree 1     6 20   5988998.1028282 2096024.0271709 37.7346489082814 -122.480477366023 (37.7346489082814, -122.480477366023) 1 8 3 64 35
178607 19464 1 260 1700X Sloat Blvd 10 Median : Cutout Tree 1     3 20   5985858.9484667 2095882.6709765 37.7340778499573 -122.491319932369 (37.7340778499573, -122.491319932369) 1 8 3 64 35
179972 19435 1 260 1300X Sloat Blvd 4 Median : Cutout Tree 1     6 20   5987408.7322245 2095946.646093 37.7343439457369 -122.485966609595 (37.7343439457369, -122.485966609595) 1 8 3 64 35
180912 19430 1 260 1200X Sloat Blvd 3 Median : Cutout Tree 1     6 20   5987947.5018995 2095985.7700738 37.7344827526385 -122.484106799366 (37.7344827526385, -122.484106799366) 1 8 3 64 35
181087 19474 1 260 1900X Sloat Blvd 1 Median : Cutout Tree 1     3 20   5984946.1404685 2095883.2432037 37.734026040705 -122.494475789917 (37.734026040705, -122.494475789917) 1 8 3 29491 35
182361 19443 1 260 1302X Sloat Blvd 6 Median : Cutout Tree 1     3 20   5987401.6755259 2095951.2124587 37.7343560725457 -122.485991341651 (37.7343560725457, -122.485991341651) 1 8 3 64 35
183242 19453 1 260 1500X Sloat Blvd 4 Median : Cutout Tree 1     24 20   5986548.4544357 2095908.9031645 37.7341901424899 -122.488938055092 (37.7341901424899, -122.488938055092) 1 8 3 64 35
186571 19387 1 260 100X Sloat Blvd 3 Median : Cutout Tree 1     30 20   5991082.2835044 2096052.6376293 37.7348483670999 -122.473273805701 (37.7348483670999, -122.473273805701) 1 8 4 29491 40
187156 19436 1 260 1300X Sloat Blvd 5 Median : Cutout Tree 1     24 20   5987408.7322245 2095946.646093 37.7343439457369 -122.485966609595 (37.7343439457369, -122.485966609595) 1 8 3 64 35
187606 19391 1 260 100X Sloat Blvd 7 Median : Cutout Tree 1     18 20   5991082.2835044 2096052.6376293 37.7348483670999 -122.473273805701 (37.7348483670999, -122.473273805701) 1 8 4 29491 40
189105 19446 1 260 1400X Sloat Blvd 3 Median : Cutout Tree 1     18 20   5986974.9102614 2095954.0242956 37.7343389133904 -122.48746699486 (37.7343389133904, -122.48746699486) 1 8 3 64 35
189351 19407 1 260 500X Sloat Blvd 4 Median : Cutout Tree 1     6 20   5989983.811155 2096024.6780472 37.7347079305354 -122.477069523101 (37.7347079305354, -122.477069523101) 1 8 3 64 35
193633 19388 1 260 100X Sloat Blvd 4 Median : Cutout Tree 1     6 20   5991082.2835044 2096052.6376293 37.7348483670999 -122.473273805701 (37.7348483670999, -122.473273805701) 1 8 4 29491 40
193657 19401 1 260 400X Sloat Blvd 1 Median : Cutout Tree 1     24 20   5990261.3597061 2096050.1007314 37.7347938328013 -122.47611180944 (37.7347938328013, -122.47611180944) 1 8 3 64 35