Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
117573 | 117573 | 28588 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Ocean Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | |||
119764 | 119764 | 28589 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Ocean Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 6 | 3X3 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | ||
144482 | 144482 | 98742 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Scott St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 03/21/2012 12:00:00 AM | 3 | 4X4 | 6002360.0 | 2112467.0 | 37.780564823652504 | -122.43545670615299 | (37.7805648236525, -122.435456706153) | |
145720 | 145720 | 98741 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 03/21/2012 12:00:00 AM | 3 | 4X4 | 6002360.0 | 2112467.0 | 37.780564823652504 | -122.43545670615299 | (37.7805648236525, -122.435456706153) | |
132171 | 132171 | 242912 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1154 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6004415.185819999 | 2102148.8561 | 37.7523501901347 | -122.427611502469 | (37.7523501901347, -122.427611502469) | |||
118573 | 118573 | 120668 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1154 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5998951.0 | 2105925.0 | 37.76240795737721 | -122.44677915122601 | (37.7624079573772, -122.446779151226) | |||
28712 | 28712 | 82088 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 116 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 9 | 3x3 | Permit Number 50668 | 5996122.25454 | 2115757.75082 | 37.789244107281604 | -122.45727402588001 | (37.7892441072816, -122.45727402588) | |
38984 | 38984 | 82050 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 116 Cherry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50668 | 5996119.951719999 | 2115777.79007 | 37.78929899740071 | -122.457283443584 | (37.7892989974007, -122.457283443584) | |
21836 | 21836 | 10190 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1160 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/2015 09:38:00 AM | 3 | 2x2 | 6005734.23383 | 2102203.6860700003 | 37.7525752625596 | -122.42305391193001 | (37.7525752625596, -122.42305391193) | ||
14663 | 14663 | 28516 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 117 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x4 | 6010207.243969999 | 2112381.64795 | 37.7807730152091 | -122.40830321374901 | (37.7807730152091, -122.408303213749) | |||
126876 | 126876 | 50286 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 117 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | Permit Number 46994 | 6001812.465231299 | 2096668.95095007 | 37.737156097415706 | -122.436219989049 | (37.7371560974157, -122.436219989049) | ||
183009 | 183009 | 52766 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 117 Trenton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2006 12:00:00 AM | 4 | Permit Number 48808 | 6010071.7871900005 | 2117939.89762 | 37.7960270495675 | -122.409164153622 | (37.7960270495675, -122.409164153622) | ||
12988 | 12988 | 904 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1179 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2016 12:00:00 AM | 3 | 2X2 | 6003419.3756099995 | 2094263.29224 | 37.7306418725253 | -122.430492572378 | (37.7306418725253, -122.430492572378) | ||
56229 | 56229 | 83159 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 118 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52389 | 6013682.79491 | 2106471.12708 | 37.7647380590444 | -122.395865223811 | (37.7647380590444, -122.395865223811) | |
142871 | 142871 | 50812 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1185 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47335 | 6006411.34126945 | 2102697.72604522 | 37.7539699686496 | -122.42074742340598 | (37.7539699686496, -122.420747423406) | ||||
77376 | 77376 | 49717 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1195 Fitzgerald Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2003 12:00:00 AM | Permit Number 46529 | 6014698.72785663 | 2090465.4227663002 | 37.7208461876659 | -122.39123244275801 | (37.7208461876659, -122.391232442758) | |||
83435 | 83435 | 49719 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1195 Fitzgerald Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2003 12:00:00 AM | Permit Number 46529 | 6014698.72785663 | 2090465.4227663002 | 37.7208461876659 | -122.39123244275801 | (37.7208461876659, -122.391232442758) | |||
87176 | 87176 | 49716 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1195 Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2003 12:00:00 AM | Permit Number 46529 | 6014698.72785663 | 2090465.4227663002 | 37.7208461876659 | -122.39123244275801 | (37.7208461876659, -122.391232442758) | |||
159839 | 159839 | 198423 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1195 La Salle Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017270.50645 | 2094483.4459099998 | 37.7320212859403 | -122.38262193865299 | (37.7320212859403, -122.382621938653) | |||
81038 | 81038 | 17707 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1195X Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2012 12:00:00 AM | 3 | 4x4 | 6002295.810192 | 2112602.9289849997 | 37.78093440458979 | -122.435688496636 | (37.7809344045898, -122.435688496636) | ||
98332 | 98332 | 17706 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1195X Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2012 12:00:00 AM | 3 | 4x4 | 6002295.810192 | 2112602.9289849997 | 37.78093440458979 | -122.435688496636 | (37.7809344045898, -122.435688496636) | ||
66929 | 66929 | 198422 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1196 La Salle Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017170.944180001 | 2094491.5929599998 | 37.7320381554174 | -122.38296671716199 | (37.7320381554174, -122.382966717162) | |||
130533 | 130533 | 198421 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1196 La Salle Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017061.11221 | 2094548.33613 | 37.732187891662896 | -122.383350382316 | (37.7321878916629, -122.383350382316) | |||
71767 | 71767 | 198424 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1197 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017092.18151 | 2094577.95359 | 37.7322709323521 | -122.38324502853999 | (37.7322709323521, -122.38324502854) | |||
50950 | 50950 | 246860 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1198 Oak St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6001322.98115 | 2109744.38173 | 37.773030249875795 | -122.43884907734301 | (37.7730302498758, -122.438849077343) | |||
179692 | 179692 | 246859 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1198 Oak St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6001348.19607 | 2109746.2469900004 | 37.7730368059387 | -122.43876198966998 | (37.7730368059387, -122.43876198967) | |||
39498 | 39498 | 198275 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1199 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 6011697.22277 | 2102839.72016 | 37.754656360309994 | -122.40247746938 | (37.75465636031, -122.40247746938) | |||
74713 | 74713 | 198308 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Brannan St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015701.627180001 | 2113485.85575 | 37.7841110576194 | -122.389372445082 | (37.7841110576194, -122.389372445082) | |||
132456 | 132456 | 198307 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Brannan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015819.881580001 | 2113595.44766 | 37.784418527738204 | -122.388970977841 | (37.7844185277382, -122.388970977841) | |||
162847 | 162847 | 198309 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Brannan St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015688.10696 | 2113472.66106 | 37.7840740783932 | -122.389418298834 | (37.7840740783932, -122.389418298834) | |||
156961 | 156961 | 32340 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Burrows St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | 8 | Permit Number 36902 | 6010864.0771699995 | 2093419.2397900003 | 37.7287432013131 | -122.40469557435 | (37.7287432013131, -122.40469557435) | ||
119664 | 119664 | 94667 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Cuvier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53804 | 6003993.0 | 2095197.0 | 37.733238102358 | -122.42857599617099 | (37.733238102358, -122.428575996171) | |
31042 | 31042 | 198387 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6011311.4774 | 2113337.57021 | 37.7834595257768 | -122.404550424668 | (37.7834595257768, -122.404550424668) | |||
38555 | 38555 | 198390 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6011047.1046400005 | 2113083.17782 | 37.7827462455888 | -122.405447134184 | (37.7827462455888, -122.405447134184) | |||
45489 | 45489 | 198383 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6011433.08529 | 2113455.1444200003 | 37.783789152501996 | -122.404137983874 | (37.783789152502, -122.404137983874) | |||
57375 | 57375 | 198392 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6011000.014830001 | 2113040.11829 | 37.7826253811877 | -122.40560701207899 | (37.7826253811877, -122.405607012079) | |||
72913 | 72913 | 198388 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6011155.22341 | 2113196.02476 | 37.7830621414549 | -122.40508103546101 | (37.7830621414549, -122.405081035461) | |||
121282 | 121282 | 198393 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010986.3468 | 2113026.7242099997 | 37.782587839895704 | -122.40565335414401 | (37.7825878398957, -122.405653354144) | |||
129565 | 129565 | 198385 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6011340.58329 | 2113365.77495 | 37.7835385959651 | -122.404451715074 | (37.7835385959651, -122.404451715074) | |||
137125 | 137125 | 198391 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6011033.457280001 | 2113070.7839 | 37.7827114517206 | -122.405493475357 | (37.7827114517206, -122.405493475357) | |||
137982 | 137982 | 198386 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6011328.567000001 | 2113354.5628299997 | 37.783507138591 | -122.40449249752399 | (37.783507138591, -122.404492497524) | |||
152803 | 152803 | 198382 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6011448.39911 | 2113467.1712 | 37.7838230308611 | -122.404085850185 | (37.7838230308611, -122.404085850185) | |||
152817 | 152817 | 198384 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6011417.757619999 | 2113442.45107 | 37.783753443101 | -122.404190118502 | (37.783753443101, -122.404190118502) | |||
159480 | 159480 | 198394 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010970.67722 | 2113013.70432 | 37.782551214095 | -122.40570664706001 | (37.782551214095, -122.40570664706) | |||
166579 | 166579 | 198389 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6011138.46827 | 2113179.02511 | 37.78301452774279 | -122.40513780428499 | (37.7830145277428, -122.405137804285) | |||
176058 | 176058 | 198395 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010955.650090001 | 2112999.3376599997 | 37.7825109262834 | -122.40575762241998 | (37.7825109262834, -122.40575762242) | |||
77490 | 77490 | 25459 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2003 12:00:00 AM | 3 | 3X3 | 5993585.96467 | 2088543.99773 | 37.714376124024504 | -122.464072878916 | (37.7143761240245, -122.464072878916) | ||
92289 | 92289 | 25458 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2003 12:00:00 AM | 3 | 3X3 | 5993547.93552 | 2088545.97374 | 37.7143793578368 | -122.464204465034 | (37.7143793578368, -122.464204465034) | ||
168366 | 168366 | 217730 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1200x Arguello Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 5995796.25486 | 2107257.89675 | 37.765887025696394 | -122.45778663137101 | (37.7658870256964, -122.457786631371) | |||
130307 | 130307 | 36947 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 121 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/1998 12:00:00 AM | 9 | 6x9 | Permit Number 39582 | 5994567.08556 | 2114703.52353 | 37.78626004419979 | -122.46257818064801 | (37.7862600441998, -122.462578180648) | |
102715 | 102715 | 49568 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1219@ LINCOLN 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2003 12:00:00 AM | Permit Number 46453 | 5985494.10343232 | 2106914.89929476 | 37.764348018167 | -122.4933938427 | (37.764348018167, -122.4933938427) | |||
184089 | 184089 | 180430 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 122 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000838.328869999 | 2091757.95651 | 37.723616244584704 | -122.43923612035299 | (37.7236162445847, -122.439236120353) | |||
82363 | 82363 | 28573 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1220X Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995089.2906 | 2091962.0897099997 | 37.72384792002239 | -122.459124181231 | (37.7238479200224, -122.459124181231) | ||
104360 | 104360 | 28574 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1220X Capitol Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995089.2906 | 2091962.0897099997 | 37.72384792002239 | -122.459124181231 | (37.7238479200224, -122.459124181231) | ||
128535 | 128535 | 28571 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1220X Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995089.2906 | 2091962.0897099997 | 37.72384792002239 | -122.459124181231 | (37.7238479200224, -122.459124181231) | ||
145812 | 145812 | 28572 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1220X Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995089.2906 | 2091962.0897099997 | 37.72384792002239 | -122.459124181231 | (37.7238479200224, -122.459124181231) | ||
69123 | 69123 | 180485 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1222 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6001620.509380001 | 2087598.74128 | 37.712240447503 | -122.436234753557 | (37.712240447503, -122.436234753557) | |||
49606 | 49606 | 198325 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013787.22843 | 2108637.88784 | 37.770693312961996 | -122.39565583825899 | (37.770693312962, -122.395655838259) | ||||
59226 | 59226 | 198321 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013777.96356 | 2108496.99922 | 37.7703059488766 | -122.39567801282601 | (37.7703059488766, -122.395678012826) | ||||
66247 | 66247 | 198320 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013760.20993 | 2108475.0165 | 37.7702446016405 | -122.39573788252 | (37.7702446016405, -122.39573788252) | ||||
71393 | 71393 | 198322 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013789.7693 | 2108510.1655 | 37.7703427572515 | -122.39563809912599 | (37.7703427572515, -122.395638099126) | ||||
75545 | 75545 | 198319 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013741.4074800005 | 2108464.54508 | 37.7702148034894 | -122.395802186723 | (37.7702148034894, -122.395802186723) | ||||
148832 | 148832 | 198324 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6013797.10576 | 2108619.17547 | 37.77064248240121 | -122.39562036091101 | (37.7706424824012, -122.395620360911) | ||||
158639 | 158639 | 198326 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013771.76611 | 2108656.94068 | 37.7707447676885 | -122.39571065823601 | (37.7707447676885, -122.395710658236) | ||||
173800 | 173800 | 198327 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013747.40215 | 2108665.50559 | 37.7707669296806 | -122.395795534462 | (37.7707669296806, -122.395795534462) | ||||
175328 | 175328 | 198323 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013802.38344 | 2108531.614 | 37.7704023517081 | -122.39559596947201 | (37.7704023517081, -122.395595969472) | ||||
59628 | 59628 | 101974 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1230 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769454 | 6013882.9225 | 2105271.9580900003 | 37.7614565354174 | -122.39508902885099 | (37.7614565354174, -122.395089028851) | |
85469 | 85469 | 10201 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1233 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2006 12:00:00 AM | 3 | 3X3 | 6005829.840660599 | 2101789.0505836997 | 37.7514421637243 | -122.422693823491 | (37.7514421637243, -122.422693823491) | ||
30973 | 30973 | 198274 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1236 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011932.48905 | 2102621.16084 | 37.7540693755115 | -122.401648489597 | (37.7540693755115, -122.401648489597) | |||
41429 | 41429 | 219435 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1247 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992661.28483 | 2106962.1744 | 37.7648944511525 | -122.468608225701 | (37.7648944511525, -122.468608225701) | |||
183910 | 183910 | 219434 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1247 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992662.02386 | 2106946.976 | 37.764852763058705 | -122.46860456367399 | (37.7648527630587, -122.468604563674) | |||
113190 | 113190 | 50280 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 125 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | Permit Number 46983 | 6005892.25662181 | 2095880.17793273 | 37.7352212574826 | -122.42205825487 | (37.7352212574826, -122.42205825487) | ||
175743 | 175743 | 52767 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 125 Trenton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2006 12:00:00 AM | 4 | 1x2 | Permit Number 48809 | 6010066.728209999 | 2117984.84058 | 37.7961501685616 | -122.409184831728 | (37.7961501685616, -122.409184831728) | |
78972 | 78972 | 28575 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1250 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995113.87864 | 2092090.3781400002 | 37.7242015827796 | -122.45904846962799 | (37.7242015827796, -122.459048469628) | ||
82629 | 82629 | 28579 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1250 Capitol Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3x3 | 5995113.87864 | 2092090.3781400002 | 37.7242015827796 | -122.45904846962799 | (37.7242015827796, -122.459048469628) | ||
86549 | 86549 | 28577 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1250 Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995113.87864 | 2092090.3781400002 | 37.7242015827796 | -122.45904846962799 | (37.7242015827796, -122.459048469628) | ||
114325 | 114325 | 28578 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1250 Capitol Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995113.87864 | 2092090.3781400002 | 37.7242015827796 | -122.45904846962799 | (37.7242015827796, -122.459048469628) | ||
120407 | 120407 | 28576 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1250 Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995113.87864 | 2092090.3781400002 | 37.7242015827796 | -122.45904846962799 | (37.7242015827796, -122.459048469628) | ||
43937 | 43937 | 33280 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1250 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 3 | Permit Number 37445 | 6008548.04554 | 2116881.1658799998 | 37.7930345518418 | -122.414361665778 | (37.7930345518418, -122.414361665778) | |
185956 | 185956 | 33282 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1250 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 4 | Permit Number 37445 | 6008545.83527 | 2116894.20233 | 37.793070222573 | -122.41437023629601 | (37.793070222573, -122.414370236296) | |
148867 | 148867 | 44382 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1257 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | 10 | Permit Number 43744 | 6001457.21112 | 2087559.6242799999 | 37.71212376138379 | -122.43679636128901 | (37.7121237613838, -122.436796361289) | |
169983 | 169983 | 52768 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 125@ JACKSON Trenton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2006 12:00:00 AM | 4 | Permit Number 48809 | 6010068.15327 | 2117966.12844 | 37.796098869423496 | -122.40917857963801 | (37.7960988694235, -122.409178579638) | ||
52515 | 52515 | 123697 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 126 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995184.692290001 | 2111494.1895 | 37.777483620495296 | -122.46020883366998 | (37.7774836204953, -122.46020883367) | |||
101199 | 101199 | 90135 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 126 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5995236.784291999 | 2111488.444802 | 37.77747084326629 | -122.460028215119 | (37.7774708432663, -122.460028215119) | ||
117525 | 117525 | 12095 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1261X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/1996 12:00:00 AM | 6 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457005 | -122.383068698568 | (37.732064349457, -122.383068698568) | ||
21694 | 21694 | 10206 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1274 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2010 12:00:00 AM | 3 | 2X2 | 6005768.7769 | 2101585.68354 | 37.7508803192719 | -122.422890537479 | (37.7508803192719, -122.422890537479) | ||
77583 | 77583 | 51433 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1275 Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2004 12:00:00 AM | Permit Number 47752 | 6001334.87709496 | 2110036.2943615 | 37.7738324456338 | -122.43882885035801 | (37.7738324456338, -122.438828850358) | |||
102000 | 102000 | 51431 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1275 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2004 12:00:00 AM | Permit Number 47752 | 6001334.87709496 | 2110036.2943615 | 37.7738324456338 | -122.43882885035801 | (37.7738324456338, -122.438828850358) | |||
109800 | 109800 | 51432 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1275 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2004 12:00:00 AM | Permit Number 47752 | 6001334.87709496 | 2110036.2943615 | 37.7738324456338 | -122.43882885035801 | (37.7738324456338, -122.438828850358) | |||
33823 | 33823 | 136938 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1277 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008610.97542 | 2116946.31505 | 37.7932169703383 | -122.41414853544201 | (37.7932169703383, -122.414148535442) | |||
163047 | 163047 | 44470 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 128 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 8 | Permit Number 43784 | 6005782.65957 | 2093100.8203 | 37.727583573204896 | -122.422239770059 | (37.7275835732049, -122.422239770059) | |
25281 | 25281 | 115053 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1280 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2016 12:00:00 AM | 1 | Permit Number 773966 | 6007807.56108 | 2115848.6869799998 | 37.790157994733704 | -122.41685060786699 | (37.7901579947337, -122.416850607867) | ||
144194 | 144194 | 12106 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1281X La Salle Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/23/1996 12:00:00 AM | 6 | 3X3 | 6017033.141005999 | 2094557.4754692002 | 37.732211440602605 | -122.383447721977 | (37.7322114406026, -122.383447721977) | ||
182275 | 182275 | 136954 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 130 Chestnut St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011359.28517 | 2121128.07702 | 37.8048530581732 | -122.404933719313 | (37.8048530581732, -122.404933719313) | |||
33902 | 33902 | 201660 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 130 Dore St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6009127.89234 | 2109540.91695 | 37.7729125385177 | -122.411836435997 | (37.7729125385177, -122.411836435997) | |||
26854 | 26854 | 103532 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 130 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2014 12:00:00 AM | 1 | Permit Number 770957 | 6003118.601980001 | 2086861.7562 | 37.7103018500205 | -122.431004337903 | (37.7103018500205, -122.431004337903) | ||
36031 | 36031 | 103531 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 130 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2014 12:00:00 AM | 1 | Permit Number 770957 | 6003099.91342 | 2086880.6888299999 | 37.7103527759382 | -122.43107027978901 | (37.7103527759382, -122.431070279789) | ||
46161 | 46161 | 219422 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1301 Funston Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5992066.9106 | 2106337.95166 | 37.7631461484089 | -122.470618527048 | (37.7631461484089, -122.470618527048) | |||
48324 | 48324 | 219420 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1301 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5992057.8729 | 2106495.38821 | 37.7635779048182 | -122.470661252913 | (37.7635779048182, -122.470661252913) | |||
67459 | 67459 | 219423 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1301 Funston Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992070.57915 | 2106257.11168 | 37.7629243953779 | -122.470599950627 | (37.7629243953779, -122.470599950627) |
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");