Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantDate, PlotSize, PermitNotes
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31927 | 31927 | 117672 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 7751 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5982922.15587 | 2112497.69809 | 37.77952599164671 | -122.502702614984 | (37.7795259916467, -122.502702614984) | |||
45764 | 45764 | 117863 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 798 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5983563.66024 | 2110432.70706 | 37.7738938035198 | -122.50033069971902 | (37.7738938035198, -122.500330699719) | |||
36732 | 36732 | 54017 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 848 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2007 12:00:00 AM | 7 | 3x3 | Permit Number 49959 | 5985128.25093 | 2110100.49047 | 37.7730733441171 | -122.494894102815 | (37.7730733441171, -122.494894102815) | |
58219 | 58219 | 118168 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3238 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5985471.03875 | 2111143.13059 | 37.775956196854 | -122.493785221511 | (37.775956196854, -122.493785221511) | |||
45388 | 45388 | 118167 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3238 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5985487.69599 | 2111143.2321 | 37.775957450089 | -122.493727608092 | (37.775957450089, -122.493727608092) | |||
68356 | 68356 | 47196 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 430 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 7 | Permit Number 45156 | 5986884.14198 | 2113014.7647599997 | 37.781177745194995 | -122.48903462038 | (37.781177745195, -122.48903462038) | |
44344 | 44344 | 67959 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 7 | Permit Number 31679 | 5987285.58651 | 2110436.7954700002 | 37.774122792273204 | -122.48745641247 | (37.7741227922732, -122.48745641247) | |
34216 | 34216 | 32016 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2920 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2002 12:00:00 AM | 7 | Permit Number 46155 | 5989557.12792 | 2111970.2291 | 37.7784653891782 | -122.479711067145 | (37.7784653891782, -122.479711067145) | |
40418 | 40418 | 42151 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 554 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 7 | Permit Number 42446 | 5989728.75072 | 2111581.12126 | 37.7774069754215 | -122.47908889577499 | (37.7774069754215, -122.479088895775) | |
137904 | 137904 | 35593 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 168 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1999 12:00:00 AM | 7 | Permit Number 41773 | 5990252.30789 | 2114278.94729 | 37.784844846933105 | -122.47747498791901 | (37.7848448469331, -122.477474987919) | ||
181344 | 181344 | 219425 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1351 Funston Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992072.68272 | 2106101.95899 | 37.7624985088134 | -122.470581374239 | (37.7624985088134, -122.470581374239) | |||
170109 | 170109 | 219439 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2467 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992326.86547 | 2098646.73015 | 37.7420430772393 | -122.46915963151001 | (37.7420430772393, -122.46915963151) | |||
47862 | 47862 | 68175 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 58 Rossi Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1993 12:00:00 AM | 7 | Permit Number 31946 | 5996349.990780001 | 2111854.0137 | 37.778538561885796 | -122.45620372641399 | (37.7785385618858, -122.456203726414) | |
98617 | 98617 | 26044 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 32 Broad St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/1997 12:00:00 AM | 7 | 3X3 | 5996138.5208 | 2088089.89027 | 37.7132760340232 | -122.45521749021002 | (37.7132760340232, -122.45521749021) | ||
149078 | 149078 | 219452 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 51 Geneva Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997992.724230001 | 2091136.6840099997 | 37.7217480352132 | -122.449028100663 | (37.7217480352132, -122.449028100663) | |||
187797 | 187797 | 219451 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 51 Geneva Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998010.24374 | 2091127.2252200001 | 37.7217230655433 | -122.44896685955099 | (37.7217230655433, -122.448966859551) | |||
66456 | 66456 | 51487 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2576 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2005 12:00:00 AM | 7 | Permit Number 47799 | 5999531.677519999 | 2119487.78648 | 37.7996810220155 | -122.44574623442101 | (37.7996810220155, -122.445746234421) | ||
23639 | 23639 | 51486 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2576 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2005 12:00:00 AM | 7 | Permit Number 47799 | 5999551.99541 | 2119490.69699 | 37.799690173532 | -122.445676136766 | (37.799690173532, -122.445676136766) | ||
61605 | 61605 | 219448 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 339 Detroit St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999411.63335 | 2094313.0513799998 | 37.7305506524938 | -122.44435147316003 | (37.7305506524938, -122.44435147316) | |||
27116 | 27116 | 136928 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3835 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6000577.85991 | 2121479.43113 | 37.8052092229902 | -122.442269124421 | (37.8052092229902, -122.442269124421) | |||
130974 | 130974 | 219444 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 332 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000112.057990001 | 2094877.3481599998 | 37.7321400180385 | -122.44197049644801 | (37.7321400180385, -122.441970496448) | |||
169649 | 169649 | 180432 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 245 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000158.15201 | 2091623.21289 | 37.72320754048771 | -122.44157770136002 | (37.7232075404877, -122.44157770136) | |||
67087 | 67087 | 136917 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1921 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6000998.90013 | 2120967.06154 | 37.803826380442096 | -122.44077529025499 | (37.8038263804421, -122.440775290255) | |||
179461 | 179461 | 49307 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1800 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2003 12:00:00 AM | 7 | Permit Number 46312 | 6000553.97076 | 2093635.29726 | 37.7287548061895 | -122.440353666507 | (37.7287548061895, -122.440353666507) | ||
119588 | 119588 | 49308 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1800 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2003 12:00:00 AM | 7 | Permit Number 46312 | 6000563.36323 | 2093652.90178 | 37.7288036789249 | -122.44032245822099 | (37.7288036789249, -122.440322458221) | ||
47843 | 47843 | 49309 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1800 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2003 12:00:00 AM | 7 | Permit Number 46312 | 6000570.14327 | 2093666.4250900003 | 37.7288411968484 | -122.440299988657 | (37.7288411968484, -122.440299988657) | ||
2511 | 2511 | 246852 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 300 Broderick St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6001238.428669999 | 2109976.67902 | 37.7736632691848 | -122.43915820668998 | (37.7736632691848, -122.43915820669) | |||
164362 | 164362 | 180427 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 223 San Juan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001070.302630001 | 2092358.46674 | 37.7252783068249 | -122.438477233758 | (37.7252783068249, -122.438477233758) | |||
56868 | 56868 | 180428 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 223 San Juan Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001082.08541 | 2092350.7648 | 37.7252578292825 | -122.438435950363 | (37.7252578292825, -122.438435950363) | |||
118176 | 118176 | 247757 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 64 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6001625.44981 | 2108428.3343599997 | 37.769433914972794 | -122.437708531026 | (37.7694339149728, -122.437708531026) | |||
40561 | 40561 | 180403 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 428 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6002092.324580001 | 2093893.81656 | 37.7295521118195 | -122.435053967971 | (37.7295521118195, -122.435053967971) | |||
46824 | 46824 | 180405 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 23 Gorham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6002276.91097 | 2094198.0072599999 | 37.73039782978879 | -122.434437575327 | (37.7303978297888, -122.434437575327) | |||
32179 | 32179 | 180406 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 23 Gorham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6002284.81507 | 2094188.8168099998 | 37.7303730435723 | -122.43440959293999 | (37.7303730435723, -122.43440959294) | |||
182205 | 182205 | 242345 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 33 Digby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6003025.15888 | 2097332.31594 | 37.7390463716034 | -122.43207451582501 | (37.7390463716034, -122.432074515825) | |||
45828 | 45828 | 242335 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 240 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004310.20228 | 2099583.9062799998 | 37.7453014945788 | -122.427791810249 | (37.7453014945788, -122.427791810249) | |||
24845 | 24845 | 31207 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 141 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1995 12:00:00 AM | 7 | Permit Number 34899 | 6004741.8201 | 2109004.9334 | 37.7711938198687 | -122.42697020763 | (37.7711938198687, -122.42697020763) | ||
156185 | 156185 | 180435 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 302 Congdon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004691.62085 | 2093595.5833599998 | 37.7288804810453 | -122.42604671000099 | (37.7288804810453, -122.426046710001) | |||
62996 | 62996 | 242904 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3699 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005195.07588 | 2101930.11385 | 37.7517936572624 | -122.424898952928 | (37.7517936572624, -122.424898952928) | |||
58664 | 58664 | 242887 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1050 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005696.3409 | 2102856.44643 | 37.754365453022 | -122.423231349069 | (37.754365453022, -122.423231349069) | |||
187580 | 187580 | 242347 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1338 Stevenson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6006258.64946 | 2108864.05359 | 37.7708926495153 | -122.42171341936199 | (37.7708926495153, -122.421713419362) | |||
64340 | 64340 | 242880 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1321 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6007174.89238 | 2107740.52123 | 37.7678593198724 | -122.41846442511101 | (37.7678593198724, -122.418464425111) | |||
73088 | 73088 | 136950 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 685 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6007570.27525 | 2121602.58608 | 37.805943413335 | -122.41807968522801 | (37.805943413335, -122.418079685228) | |||
135300 | 135300 | 136946 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2314 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007580.00557 | 2120367.1472 | 37.802551758716795 | -122.417958377487 | (37.8025517587168, -122.417958377487) | |||
32498 | 32498 | 136953 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 685 North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6007628.69919 | 2121609.81563 | 37.8059665519739 | -122.41787801227 | (37.8059665519739, -122.41787801227) | |||
133630 | 133630 | 198411 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 17 Washburn St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008324.97253 | 2110526.9821200003 | 37.77557496344011 | -122.414683634757 | (37.7755749634401, -122.414683634757) | |||
134223 | 134223 | 198408 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 50 Washburn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6008425.53147 | 2110386.71944 | 37.7751954846222 | -122.41432584937 | (37.7751954846222, -122.41432584937) | |||
61797 | 61797 | 180472 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008124.54519 | 2092780.38973 | 37.726835558508704 | -122.414121162755 | (37.7268355585087, -122.414121162755) | |||
179406 | 179406 | 136936 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 985 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009249.138119999 | 2116000.66803 | 37.790656277621004 | -122.411873588818 | (37.790656277621, -122.411873588818) | |||
68930 | 68930 | 180484 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 321 Silliman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009836.35585 | 2094018.9140299999 | 37.730332285386204 | -122.408290767113 | (37.7303322853862, -122.408290767113) | |||
177436 | 177436 | 70333 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 143 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 7 | 6009984.51803 | 2093871.67123 | 37.7299362833339 | -122.407768169286 | (37.7299362833339, -122.407768169286) | ||
50074 | 50074 | 198300 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2651 Phelps St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6011874.28273 | 2093380.6999 | 37.7286937889864 | -122.40120050131 | (37.7286937889864, -122.40120050131) | |||
173502 | 173502 | 73886 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 164 South Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1994 12:00:00 AM | 7 | 6014128.33524 | 2112437.75054 | 37.78114584894679 | -122.39474208568701 | (37.7811458489468, -122.394742085687) | ||
55075 | 55075 | 74119 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 164 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1994 12:00:00 AM | 7 | 6014130.8006 | 2112451.57445 | 37.7811839433263 | -122.39473452509199 | (37.7811839433263, -122.394734525092) | ||
29284 | 29284 | 198256 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 718 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6015417.87325 | 2105664.96075 | 37.762620874174104 | -122.38980767650499 | (37.7626208741741, -122.389807676505) | |||
172008 | 172008 | 198255 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 701 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015696.1864 | 2103920.99342 | 37.7578477430893 | -122.38872333331899 | (37.7578477430893, -122.388723333319) |
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");