Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23603 | 23603 | 231527 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 127 Scott St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6002315.440669999 | 2108966.67057 | 37.7709512619163 | -122.435360399361 | (37.7709512619163, -122.435360399361) | |||
24372 | 24372 | 246497 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 319 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 6ft | 6004279.93355 | 2099832.71811 | 37.7459829621447 | -122.427914200798 | (37.7459829621447, -122.427914200798) | |||
26300 | 26300 | 230904 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 485 Dellbrook Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5996727.95407 | 2103173.3402400003 | 37.7547253509046 | -122.454269037488 | (37.7547253509046, -122.454269037488) | |||
27797 | 27797 | 193506 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 559 Texas St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013849.93104 | 2104490.9158099997 | 37.7593101288798 | -122.395148422779 | (37.7593101288798, -122.395148422779) | |||
28317 | 28317 | 231519 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 99 Laussat St | 3 | : 4 | Tree 1 | Private 1 | 19 | Width 3ft | 6004337.8019 | 2109257.12249 | 37.7718634163939 | -122.42838570006501 | (37.7718634163939, -122.428385700065) | |||
28714 | 28714 | 193502 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 612 Wisconsin St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6012667.6634599995 | 2104536.12346 | 37.7593684409261 | -122.39924047836399 | (37.7593684409261, -122.399240478364) | |||
30711 | 30711 | 247235 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 49 Castro St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6002189.582769999 | 2108332.3938700003 | 37.7692025463843 | -122.435750357108 | (37.7692025463843, -122.435750357108) | |||
32981 | 32981 | 230900 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 405 Dellbrook Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997073.34762 | 2102789.02078 | 37.753689906568496 | -122.453046838146 | (37.7536899065685, -122.453046838146) | |||
33043 | 33043 | 230910 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 468 Dellbrook Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5996737.698580001 | 2103011.4503099998 | 37.7542814005682 | -122.45422364600701 | (37.7542814005682, -122.454223646007) | |||
34500 | 34500 | 250771 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 244 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5985908.77802 | 2114250.7634799997 | 37.7845144656071 | -122.49249989847401 | (37.7845144656071, -122.492499898474) | |||
36951 | 36951 | 231522 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 243 Webster St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6004167.0864699995 | 2109636.87818 | 37.7728964712308 | -122.429003296891 | (37.7728964712308, -122.429003296891) | |||
39679 | 39679 | 193504 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2 Madera St | 6 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6012910.1881 | 2103279.1573 | 37.7559305998209 | -122.398313511155 | (37.7559305998209, -122.398313511155) | |||
39915 | 39915 | 246480 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 328 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6004200.75459 | 2099871.69589 | 37.7460855064407 | -122.428190768384 | (37.7460855064407, -122.428190768384) | |||
40114 | 40114 | 193527 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2525 Phelps St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6012134.12036 | 2093726.8643599998 | 37.729658777732396 | -122.40032652486799 | (37.7296587777324, -122.400326524868) | |||
42206 | 42206 | 250768 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 243 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5985861.97079 | 2114274.2224 | 37.78457614022079 | -122.492663561571 | (37.7845761402208, -122.492663561571) | |||
47097 | 47097 | 230909 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 473 Dellbrook Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5996709.05798 | 2103059.9736900004 | 37.7544129911764 | -122.45432619661699 | (37.7544129911764, -122.454326196617) | |||
50112 | 50112 | 250548 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 120 El Camino Del Mar | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 5988224.68514 | 2115371.29245 | 37.787726251325395 | -122.484569968025 | (37.7877262513254, -122.484569968025) | |||
51914 | 51914 | 250552 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 120 El Camino Del Mar | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 5988200.97229 | 2115369.68376 | 37.7877204533879 | -122.484651890886 | (37.7877204533879, -122.484651890886) | |||
53630 | 53630 | 247664 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 114 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6001955.09074 | 2108392.82187 | 37.7693551442537 | -122.436565776903 | (37.7693551442537, -122.436565776903) | |||
56058 | 56058 | 193503 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2 Madera St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012927.740180001 | 2103279.90991 | 37.755933644031 | -122.39825286269199 | (37.755933644031, -122.398252862692) | |||
56233 | 56233 | 230906 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 481 Dellbrook Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5996721.87122 | 2103138.12849 | 37.7546283194481 | -122.45428753027001 | (37.7546283194481, -122.45428753027) | |||
58100 | 58100 | 231523 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 165 Octavia St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 7ft | 6005584.77535 | 2109912.82744 | 37.773734306612795 | -122.424118966416 | (37.7737343066128, -122.424118966416) | |||
58489 | 58489 | 230915 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 200 Palo Alto Ave | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5997614.2813800005 | 2103893.01005 | 37.7567521718816 | -122.451255790642 | (37.7567521718816, -122.451255790642) | |||
59473 | 59473 | 246492 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 377 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 5ft | 6004118.95016 | 2099820.41125 | 37.7459400617793 | -122.42846998271901 | (37.7459400617793, -122.428469982719) | |||
59891 | 59891 | 193500 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 612 Wisconsin St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012665.6188900005 | 2104560.65985 | 37.7594356985098 | -122.399249271935 | (37.7594356985098, -122.399249271935) | |||
60502 | 60502 | 250769 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 243 32nd Ave | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5985862.54385 | 2114271.7143599996 | 37.7845692873761 | -122.49266139422501 | (37.7845692873761, -122.492661394225) | |||
60887 | 60887 | 230912 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 468 Dellbrook Ave | 3 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 5996749.26701 | 2103076.56127 | 37.7544608423163 | -122.454188342215 | (37.7544608423163, -122.454188342215) | |||
62646 | 62646 | 231524 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 161 Octavia St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6005587.85343 | 2109890.98692 | 37.773674511615 | -122.42410676531901 | (37.773674511615, -122.424106765319) | |||
68344 | 68344 | 250494 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 346 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5987480.35945 | 2115339.08253 | 37.7875944385888 | -122.487142792619 | (37.7875944385888, -122.487142792619) | |||
70159 | 70159 | 201924 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 113 Elmira St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6011211.39795 | 2096100.72359 | 37.7361253987577 | -122.403683453948 | (37.7361253987577, -122.403683453948) | |||
70627 | 70627 | 193524 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1994 Carroll Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012105.785130001 | 2093511.8237299998 | 37.729066740518206 | -122.40040938479099 | (37.7290667405182, -122.400409384791) | |||
71805 | 71805 | 231526 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 151 Octavia St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6005594.534659999 | 2109838.51296 | 37.7735308080253 | -122.424079921455 | (37.7735308080253, -122.424079921455) | |||
71883 | 71883 | 231780 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 3980 22nd St | 3 | : 4 | Tree 1 | Private 1 | 1 | 6001950.55974 | 2102952.70608 | 37.7544176532747 | -122.43619208522101 | (37.7544176532747, -122.436192085221) | ||||
73146 | 73146 | 247661 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 117 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6001902.18667 | 2108371.43994 | 37.7692934282776 | -122.436747238498 | (37.7692934282776, -122.436747238498) | |||
75176 | 75176 | 246478 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 324 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6004249.43735 | 2099875.64697 | 37.746099109581706 | -122.42802271119 | (37.7460991095817, -122.42802271119) | |||
76315 | 76315 | 231913 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 3977 22nd St | 5 | : 4 | Tree 1 | Private 1 | 1 | Width 8ft | 6001945.98692 | 2102924.95269 | 37.754341189313 | -122.436205913185 | (37.754341189313, -122.436205913185) | |||
131334 | 131334 | 193501 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 612 Wisconsin St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012667.01011 | 2104548.53008 | 37.759402470364 | -122.399243608899 | (37.759402470364, -122.399243608899) | |||
133088 | 133088 | 193526 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2555 Phelps St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6012059.21208 | 2093630.8530400002 | 37.729390973092606 | -122.40057875052901 | (37.7293909730926, -122.400578750529) | |||
133893 | 133893 | 246491 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 381 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6004093.63672 | 2099817.69369 | 37.745931167494 | -122.428557319471 | (37.745931167494, -122.428557319471) | |||
137289 | 137289 | 193510 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2300 Cesar Chavez St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012188.87761 | 2100979.57503 | 37.7495762411476 | -122.400646518042 | (37.7495762411476, -122.400646518042) | |||
147097 | 147097 | 230907 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 477 Dellbrook Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5996716.40558 | 2103109.1973900003 | 37.7545485684711 | -122.454304342178 | (37.7545485684711, -122.454304342178) | |||
150020 | 150020 | 193507 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 354 Texas St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6013737.5331 | 2105442.57738 | 37.7619169325541 | -122.395603828673 | (37.7619169325541, -122.395603828673) | |||
152077 | 152077 | 230901 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 405 Dellbrook Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997094.12103 | 2102782.77809 | 37.753673956202 | -122.452974548836 | (37.753673956202, -122.452974548836) | |||
152895 | 152895 | 193508 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 201 Connecticut St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6013201.7782 | 2106062.47308 | 37.763589213801204 | -122.397500283904 | (37.7635892138012, -122.397500283904) | |||
154496 | 154496 | 193525 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2555 Phelps St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012034.50381 | 2093597.5049700001 | 37.7292980281618 | -122.4006618281 | (37.7292980281618, -122.4006618281) | |||
154897 | 154897 | 230913 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 476 Dellbrook Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5996761.65493 | 2103157.62953 | 37.7546841457824 | -122.454151356723 | (37.7546841457824, -122.454151356723) | |||
156724 | 156724 | 231525 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 157 Octavia St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6005589.98933 | 2109874.78522 | 37.7736301462565 | -122.424098224478 | (37.7736301462565, -122.424098224478) | |||
158350 | 158350 | 247673 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 23 Castro St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6002150.24034 | 2108430.52442 | 37.7694697538428 | -122.435893462629 | (37.7694697538428, -122.435893462629) | |||
159566 | 159566 | 193528 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 98 Augusta St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6011272.08461 | 2095492.7569400002 | 37.7344594406581 | -122.403430875739 | (37.7344594406581, -122.403430875739) | |||
161619 | 161619 | 230914 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 200 Palo Alto Ave | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5997626.386030001 | 2103893.8519200003 | 37.7567551765194 | -122.45121398924299 | (37.7567551765194, -122.451213989243) | |||
161741 | 161741 | 231521 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 243 Webster St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6004163.51451 | 2109648.3283 | 37.772927708274004 | -122.429016469242 | (37.772927708274, -122.429016469242) | |||
163726 | 163726 | 250546 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 120 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5988227.83471 | 2115369.81789 | 37.7877223860179 | -122.484558963049 | (37.7877223860179, -122.484558963049) | |||
164820 | 164820 | 230902 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 510 Dellbrook Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5996790.89469 | 2103324.02903 | 37.755142713688 | -122.45406225549499 | (37.755142713688, -122.454062255495) | |||
166753 | 166753 | 230916 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 125 Saint Germain Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997709.14889 | 2104114.17746 | 37.7573648736996 | -122.450943653051 | (37.7573648736996, -122.450943653051) | |||
167224 | 167224 | 231518 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 64 Elgin Park | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6005812.36604 | 2108744.76303 | 37.7705399299904 | -122.423248645727 | (37.7705399299904, -122.423248645727) | |||
170203 | 170203 | 231520 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 255 Webster St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6004160.3821 | 2109699.58772 | 37.773068276806995 | -122.42903096001001 | (37.773068276807, -122.42903096001) | |||
170612 | 170612 | 230905 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 485 Dellbrook Ave | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5996724.64447 | 2103154.52974 | 37.754673512200206 | -122.454279124295 | (37.7546735122002, -122.454279124295) | |||
170943 | 170943 | 246496 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 323 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6004247.31267 | 2099828.24572 | 37.745968836490604 | -122.42802668078501 | (37.7459688364906, -122.428026680785) | |||
173357 | 173357 | 131092 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 3299 Gough St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 5ft | 6004551.929269999 | 2120763.26288 | 37.803468504236605 | -122.42846528646601 | (37.8034685042366, -122.428465286466) | |||
174321 | 174321 | 193505 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 564 Texas St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6013792.13908 | 2104452.18715 | 37.759200574356 | -122.395345583834 | (37.759200574356, -122.395345583834) | |||
176488 | 176488 | 193509 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1950 Cesar Chavez St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6013323.85755 | 2101041.70464 | 37.749810071192705 | -122.39672604766301 | (37.7498100711927, -122.396726047663) | |||
177542 | 177542 | 209605 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 274 Tara St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997733.16955 | 2090269.0506799999 | 37.7193508680382 | -122.44986281181299 | (37.7193508680382, -122.449862811813) | |||
177596 | 177596 | 230917 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 125 Saint Germain Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997725.8758 | 2104116.73426 | 37.7573728516046 | -122.45088598942301 | (37.7573728516046, -122.450885989423) | |||
177694 | 177694 | 230908 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 473 Dellbrook Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5996713.27887 | 2103075.8606 | 37.7544568547024 | -122.454312747253 | (37.7544568547024, -122.454312747253) | |||
178352 | 178352 | 250493 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 346 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5987501.66991 | 2115342.63083 | 37.787605423791106 | -122.48706932428499 | (37.7876054237911, -122.487069324285) | |||
179485 | 179485 | 131091 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 3299 Gough St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6004549.167669999 | 2120777.63137 | 37.8035078001114 | -122.428475867867 | (37.8035078001114, -122.428475867867) | |||
180625 | 180625 | 230903 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 510 Dellbrook Ave | 2 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 5996798.21282 | 2103348.56462 | 37.7552105018756 | -122.454038719332 | (37.7552105018756, -122.454038719332) | |||
182705 | 182705 | 250547 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 120 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5988224.27982 | 2115368.83764 | 37.7877194875147 | -122.484571190206 | (37.7877194875147, -122.484571190206) | |||
185111 | 185111 | 131064 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1877 Greenwich St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6003926.06281 | 2119346.70194 | 37.79954355884429 | -122.430529985984 | (37.7995435588443, -122.430529985984) | |||
187462 | 187462 | 246482 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 334 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004129.100269999 | 2099867.2658599997 | 37.7460692880854 | -122.42843822405399 | (37.7460692880854, -122.428438224054) | |||
188452 | 188452 | 230911 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 468 Dellbrook Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5996742.41539 | 2103027.81097 | 37.7543265933203 | -122.454208515815 | (37.7543265933203, -122.454208515815) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");