trees
1,024 rows where qSpecies_id = 72 sorted by TreeID
This data as json, CSV (advanced)
rowid | TreeID ▼ | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
144530 | 100554 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1050X Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007651 | 2109542 | 37.7728325469688 | -122.416945272606 | (37.7728325469688, -122.416945272606) | 8 | 2 | 9 | 28853 | 19 | |||
77729 | 100555 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1050X Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007651 | 2109542 | 37.7728325469688 | -122.416945272606 | (37.7728325469688, -122.416945272606) | 8 | 2 | 9 | 28853 | 19 | |||
152749 | 100874 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 995 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 6010596.81703 | 2112015.71985 | 37.7797900696951 | -122.406929686375 | (37.7797900696951, -122.406929686375) | 14 | 2 | 9 | 28853 | 34 | ||||
79536 | 100875 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 995 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6010609.42845 | 2112029.45593 | 37.7798284914364 | -122.406887026109 | (37.7798284914364, -122.406887026109) | 14 | 2 | 9 | 28853 | 34 | ||||
97022 | 101530 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1030 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x3 | 5995974.8 | 2090771.5 | 37.7206297100162 | -122.455977107218 | (37.7206297100162, -122.455977107218) | 9 | 8 | 6 | 28861 | 24 | |||
165336 | 101531 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1030 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x3 | 5995974.8 | 2090771.5 | 37.7206297100162 | -122.455977107218 | (37.7206297100162, -122.455977107218) | 9 | 8 | 6 | 28861 | 24 | |||
128219 | 101903 | Property Tree 8 | Washingtonia robusta :: Mexican Fan Palm 72 | 1100 Ocean Ave | 4 | Front Yard : Yard | Tree | DPW 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | 9 | 7 | 4 | 28861 | 40 | ||||
191552 | 101904 | Property Tree 8 | Washingtonia robusta :: Mexican Fan Palm 72 | 1100 Ocean Ave | 5 | Front Yard : Yard | Tree | DPW 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | 9 | 7 | 4 | 28861 | 40 | ||||
144842 | 101905 | Property Tree 8 | Washingtonia robusta :: Mexican Fan Palm 72 | 1100 Ocean Ave | 6 | Front Yard : Yard | Tree | DPW 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | 9 | 7 | 4 | 28861 | 40 | ||||
161612 | 102418 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 201 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010625.41098 | 2111944.37614 | 37.7795957765601 | -122.406825737323 | (37.7795957765601, -122.406825737323) | 14 | 2 | 9 | 28853 | 34 | |||
164154 | 102419 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 201 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010609.19256 | 2111959.7498 | 37.7796370815369 | -122.406882927918 | (37.7796370815369, -122.406882927918) | 14 | 2 | 9 | 28853 | 34 | |||
92502 | 102420 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 101 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6010175.35097 | 2112415.36622 | 37.7808638116673 | -122.408415926663 | (37.7808638116673, -122.408415926663) | 14 | 2 | 9 | 28853 | 34 | |||
4818 | 102421 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 101 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010161.06831 | 2112431.87946 | 37.7809083532874 | -122.408466502752 | (37.7809083532874, -122.408466502752) | 14 | 2 | 9 | 28853 | 34 | |||
139922 | 102426 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 100 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010110.95279 | 2112392.33205 | 37.780796958746 | -122.408637087058 | (37.780796958746, -122.408637087058) | 14 | 2 | 9 | 28853 | 34 | |||
186817 | 102428 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 184 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010438.87034 | 2112046.078 | 37.7798645866165 | -122.407478236832 | (37.7798645866165, -122.407478236832) | 14 | 2 | 9 | 28853 | 34 | |||
14666 | 102429 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 200 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010552.49087 | 2111923.99595 | 37.7795357369219 | -122.407076563634 | (37.7795357369219, -122.407076563634) | 14 | 2 | 9 | 28853 | 34 | |
728 | 102430 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 200 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010566.09371 | 2111909.33227 | 37.7794962351107 | -122.407028471514 | (37.7794962351107, -122.407028471514) | 14 | 2 | 9 | 28853 | 34 | |
115969 | 102431 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 982 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4x4 | 6010575.87494 | 2112088.03468 | 37.7799874573922 | -122.407007233096 | (37.7799874573922, -122.407007233096) | 14 | 2 | 9 | 28853 | 34 | |||
77689 | 102432 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 982 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | 4x4 | 6010557.78599 | 2112071.21552 | 37.7799402636687 | -122.407068625328 | (37.7799402636687, -122.407068625328) | 14 | 2 | 9 | 28853 | 34 | |||
191738 | 102441 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1007X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010078.92624 | 2112396.71132 | 37.7808071894337 | -122.408748191999 | (37.7808071894337, -122.408748191999) | 14 | 2 | 9 | 28853 | 34 | |||
131216 | 104511 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 491-497 Alvarado St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6003187 | 2102698 | 37.7537884621117 | -122.431897972615 | (37.7537884621117, -122.431897972615) | 2 | 4 | 5 | 28862 | 22 | |||
65946 | 104512 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 491-497 Alvarado St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6003187 | 2102698 | 37.7537884621117 | -122.431897972615 | (37.7537884621117, -122.431897972615) | 2 | 4 | 5 | 28862 | 22 | |||
27021 | 104513 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 491-497 Alvarado St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6003187 | 2102698 | 37.7537884621117 | -122.431897972615 | (37.7537884621117, -122.431897972615) | 2 | 4 | 5 | 28862 | 22 | |||
197 | 104920 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 750 Gonzalez Dr | 1 | Median : Yard | Tree | Private 2 | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | |||||
99190 | 104921 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 750 Gonzalez Dr | 2 | Median : Yard | Tree | Private 2 | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | |||||
145777 | 104922 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 750 Gonzalez Dr | 3 | Median : Yard | Tree | Private 2 | missing? | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | ||||
182377 | 104926 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Gonzalez Dr | 1 | Median : Yard | Tree | Private 2 | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | |||||
1969 | 104927 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Gonzalez Dr | 2 | Median : Yard | Tree | Private 2 | 10 | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | ||||
33112 | 104928 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Gonzalez Dr | 3 | Median : Yard | Tree | Private 2 | 12 | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | ||||
167513 | 105068 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 117 PROSPECT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006924.9 | 2098775.6 | 37.7432296312701 | -122.41869328836 | (37.7432296312701, -122.41869328836) | 2 | 7 | 7 | 28859 | 2 | ||||
13473 | 105162 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1600X OAKDALE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5x5 | 6015006 | 2095503 | 37.7346954145828 | -122.390522107646 | (37.7346954145828, -122.390522107646) | 10 | 3 | 8 | 58 | 1 | |||
125248 | 106038 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 230 Lakeview Ave | Front Yard : Yard | Tree | Private 2 | Permit Number 772456 | 5997013.1 | 2089546.6 | 37.7173259605404 | -122.452299707743 | (37.7173259605404, -122.452299707743) | 9 | 8 | 6 | 28861 | 24 | |||||
155417 | 106315 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 1199X OCEAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777362 | 5996259 | 2091739 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | 9 | 8 | 4 | 28861 | 24 | |
166781 | 107420 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 62 Naples St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 23 | 6004646.42863 | 2093164.03186 | 37.7276929820452 | -122.426172231973 | (37.7276929820452, -122.426172231973) | 9 | 7 | 6 | 28861 | 5 | ||||
113506 | 108002 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 461X Ivy St | 1 | Front Yard : Cutout | Tree | Private 2 | 6005199.36333 | 2111122.83043 | 37.7770349120596 | -122.425538300101 | (37.7770349120596, -122.425538300101) | 7 | 9 | 11 | 28852 | 10 | |||||
170978 | 108021 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 455X Ivy St | 1 | Front Yard : Cutout | Tree | Private 2 | 6005179.30837 | 2111099.83336 | 37.776970634543 | -122.42560603936 | (37.776970634543, -122.42560603936) | 7 | 9 | 11 | 28852 | 10 | |||||
28320 | 108203 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1875 MISSION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006816.6 | 2107468.6 | 37.767092511705 | -122.41968442346 | (37.767092511705, -122.41968442346) | 8 | 4 | 7 | 28853 | 19 | ||||
21612 | 108537 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 400-422X Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 6012472.22935 | 2086696.28114 | 37.7103730628368 | -122.39866445541 | (37.7103730628368, -122.39866445541) | 10 | 3 | 8 | 309 | 1 | ||||
45532 | 108808 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 542 Moscow St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774650 | 6003656.47159 | 2090041.31767 | 37.7190626969286 | -122.429371938322 | (37.7190626969286, -122.429371938322) | 9 | 7 | 6 | 28861 | 5 | |
35898 | 109279 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4205 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773691 | 5981200.9 | 2104121 | 37.7564247125175 | -122.508035196592 | (37.7564247125175, -122.508035196592) | 1 | 8 | 3 | 56 | 35 |
167927 | 109280 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4205 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773691 | 5981200.9 | 2104121 | 37.7564247125175 | -122.508035196592 | (37.7564247125175, -122.508035196592) | 1 | 8 | 3 | 56 | 35 |
94788 | 109281 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4205 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773691 | 5981200.9 | 2104121 | 37.7564247125175 | -122.508035196592 | (37.7564247125175, -122.508035196592) | 1 | 8 | 3 | 56 | 35 |
138663 | 112172 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 998X MISSION ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010071 | 2112545 | 37.7812139111906 | -122.408786077679 | (37.7812139111906, -122.408786077679) | 14 | 2 | 9 | 28853 | 34 | ||||
118318 | 112500 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 301 SANCHEZ ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003576 | 2106249 | 37.7635607058029 | -122.430806117119 | (37.7635607058029, -122.430806117119) | 15 | 4 | 5 | 28862 | 3 | ||||
84329 | 113402 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2032 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 3x3 | 6006483 | 2117763 | 37.7953396281575 | -122.421569509833 | (37.7953396281575, -122.421569509833) | 13 | 9 | 10 | 28858 | 32 | ||
162489 | 115081 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1546 33RD AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 5985952 | 2104698 | 37.7582878007794 | -122.491646926351 | (37.7582878007794, -122.491646926351) | 1 | 8 | 3 | 56 | 35 | |||
186409 | 115490 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 280 BRIGHTON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2016 12:00:00 AM | 3 | 4x12 | Permit Number 777362 | 5996259 | 2091739 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | 9 | 8 | 4 | 28861 | 24 | |
71090 | 115491 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 280 BRIGHTON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2016 12:00:00 AM | 3 | 4x12 | Permit Number 777362 | 5996259 | 2091739 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | 9 | 8 | 4 | 28861 | 24 | |
27737 | 115492 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 280 BRIGHTON AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2016 12:00:00 AM | 3 | 4x12 | Permit Number 777362 | 5996259 | 2091739 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | 9 | 8 | 4 | 28861 | 24 | |
65049 | 115493 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 280 BRIGHTON AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2016 12:00:00 AM | 3 | 4x12 | Permit Number 777362 | 5996259 | 2091739 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | 9 | 8 | 4 | 28861 | 24 | |
46086 | 115494 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 1199X OCEAN AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777362 | 5996259 | 2091739 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | 9 | 8 | 4 | 28861 | 24 | |
23597 | 115495 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 1199X OCEAN AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777362 | 5996259 | 2091739 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | 9 | 8 | 4 | 28861 | 24 | |
183344 | 116595 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 800x SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002075 | 2111247 | 37.7771988203893 | -122.436355315705 | (37.7771988203893, -122.436355315705) | 15 | 5 | 11 | 29492 | 41 | ||||
32538 | 116596 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 800x SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002075 | 2111247 | 37.7771988203893 | -122.436355315705 | (37.7771988203893, -122.436355315705) | 15 | 5 | 11 | 29492 | 41 | ||||
57724 | 116597 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 800x SCOTT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002075 | 2111247 | 37.7771988203893 | -122.436355315705 | (37.7771988203893, -122.436355315705) | 15 | 5 | 11 | 29492 | 41 | ||||
29353 | 117922 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 683 41st Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5983174.69691 | 2111166.71748 | 37.7758863445675 | -122.501730482451 | (37.7758863445675, -122.501730482451) | 11 | 6 | 2 | 55 | 26 | |||
188619 | 118014 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 472 37th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 6ft | 5984415.81444 | 2112632.82053 | 37.7799846626847 | -122.49754547051 | (37.7799846626847, -122.49754547051) | 11 | 6 | 2 | 55 | 26 | |||
123764 | 118305 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 399X Willard St North | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5996275.15044137 | 2110427.69020243 | 37.7746179560473 | -122.456359464233 | (37.7746179560473, -122.456359464233) | 11 | 5 | 2 | 54 | 16 | ||||
88582 | 118306 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 399X Willard St North | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5996275.15044137 | 2110427.69020243 | 37.7746179560473 | -122.456359464233 | (37.7746179560473, -122.456359464233) | 11 | 5 | 2 | 54 | 16 | ||||
188474 | 118483 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 8349 Geary Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 5981073.18846 | 2112308.0171 | 37.7788963529663 | -122.509084778585 | (37.7788963529663, -122.509084778585) | 11 | 6 | 2 | 55 | 26 | ||||
151969 | 118484 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 8349 Geary Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 5981049.15965 | 2112307.0389 | 37.7788922504996 | -122.509167829635 | (37.7788922504996, -122.509167829635) | 11 | 6 | 2 | 55 | 26 | ||||
59325 | 118709 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4201 Balboa St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5982467.72104 | 2110969.09723 | 37.7753021852736 | -122.504161410758 | (37.7753021852736, -122.504161410758) | 11 | 6 | 2 | 55 | 26 | |||
131497 | 119374 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 866 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5986063.1424 | 2109995.79652 | 37.7728405660437 | -122.491652532111 | (37.7728405660437, -122.491652532111) | 11 | 6 | 2 | 55 | 26 | |||
107615 | 121415 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 366 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6006692 | 2103986 | 37.7575230865131 | -122.419868246156 | (37.7575230865131, -122.419868246156) | 2 | 4 | 7 | 28859 | 19 | |||
131057 | 121416 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 366 San Carlos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006692 | 2103986 | 37.7575230865131 | -122.419868246156 | (37.7575230865131, -122.419868246156) | 2 | 4 | 7 | 28859 | 19 | ||||
29167 | 121439 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1750 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6015597 | 2107388 | 37.7673618983766 | -122.389308462256 | (37.7673618983766, -122.389308462256) | 14 | 3 | 9 | 310 | 20 | ||||
135017 | 121440 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1750 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6015597 | 2107388 | 37.7673618983766 | -122.389308462256 | (37.7673618983766, -122.389308462256) | 14 | 3 | 9 | 310 | 20 | ||||
133893 | 121441 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1750 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6015597 | 2107388 | 37.7673618983766 | -122.389308462256 | (37.7673618983766, -122.389308462256) | 14 | 3 | 9 | 310 | 20 | ||||
125105 | 121442 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1750 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6015597 | 2107388 | 37.7673618983766 | -122.389308462256 | (37.7673618983766, -122.389308462256) | 14 | 3 | 9 | 310 | 20 | ||||
90115 | 121443 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1750 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6015597 | 2107388 | 37.7673618983766 | -122.389308462256 | (37.7673618983766, -122.389308462256) | 14 | 3 | 9 | 310 | 20 | ||||
43523 | 122635 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 260 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6006915 | 2105702 | 37.7622473847542 | -122.419218743707 | (37.7622473847542, -122.419218743707) | 8 | 4 | 7 | 28859 | 19 | |||
26928 | 124333 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 172 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5995945.98292 | 2113131.373 | 37.7820226523243 | -122.45769378533 | (37.7820226523243, -122.45769378533) | 11 | 6 | 1 | 54 | 31 | |||
32561 | 124341 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 105 Palm Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5995870.37991 | 2113683.65327 | 37.7835347232349 | -122.457995315637 | (37.7835347232349, -122.457995315637) | 11 | 6 | 1 | 54 | 31 | |||
176948 | 124342 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 105 Palm Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5995870.42219 | 2113701.84259 | 37.7835846686773 | -122.457996486135 | (37.7835846686773, -122.457996486135) | 11 | 6 | 1 | 54 | 31 | |||
70316 | 124343 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 105 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5995870.59128 | 2113726.09219 | 37.7836512613147 | -122.457997656644 | (37.7836512613147, -122.457997656644) | 11 | 6 | 1 | 54 | 31 | |||
24365 | 124344 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 105 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 5995869.2461 | 2113758.79509 | 37.7837409774514 | -122.458004677882 | (37.7837409774514, -122.458004677882) | 11 | 6 | 1 | 54 | 31 | |||
148383 | 124558 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 90 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5995920.27647 | 2113881.21497 | 37.7840800415509 | -122.457836994738 | (37.7840800415509, -122.457836994738) | 11 | 6 | 1 | 54 | 31 | |||
175803 | 124559 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 90 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5995921.75191 | 2113853.09729 | 37.7840029226817 | -122.45782985493 | (37.7840029226817, -122.45782985493) | 11 | 6 | 1 | 54 | 31 | |||
3346 | 137500 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 52 Iris Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 5997635.71873 | 2114163.76026 | 37.7849542395006 | -122.451922604659 | (37.7849542395006, -122.451922604659) | 15 | 6 | 1 | 54 | 31 | |||
70057 | 137501 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2317 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6000760.82972 | 2119605.96149 | 37.8000756013698 | -122.441501414554 | (37.8000756013698, -122.441501414554) | 13 | 9 | 1 | 57 | 17 | |||
185172 | 137502 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1360 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6008496.5924 | 2117239.72456 | 37.7940161753676 | -122.414565081618 | (37.7940161753676, -122.414565081618) | 5 | 1 | 10 | 28857 | 21 | |||
6999 | 137503 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1142 Filbert St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 3ft | 6007446.54333 | 2119552.35251 | 37.8003070257165 | -122.418362418606 | (37.8003070257165, -122.418362418606) | 5 | 1 | 1 | 28858 | 32 | |||
103195 | 137504 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2521 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6007440.32409 | 2121045.18765 | 37.8044056238841 | -122.418489853424 | (37.8044056238841, -122.418489853424) | 5 | 1 | 1 | 28858 | 32 | |||
175206 | 137505 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2521 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6007440.6556 | 2121042.48362 | 37.8043982179661 | -122.418488514346 | (37.8043982179661, -122.418488514346) | 5 | 1 | 1 | 28858 | 32 | |||
34027 | 137506 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 150 Francisco St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 3ft | 6010570.56702 | 2121351.03968 | 37.8054211392381 | -122.407678906174 | (37.8054211392381, -122.407678906174) | 3 | 1 | 10 | 308 | 23 | |||
143497 | 15064 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1X Minerva St | 7 | Median : Cutout | Tree | DPW 1 | 6 | 11 | 5995989.76979 | 2089004.05491 | 37.715777580947 | -122.455797663726 | (37.715777580947, -122.455797663726) | 9 | 8 | 6 | 28861 | 24 | |||
165898 | 15067 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1 Minerva St | 9 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996019.74584 | 2089003.9616 | 37.7157790450506 | -122.455694046564 | (37.7157790450506, -122.455694046564) | 9 | 8 | 6 | 28861 | 24 | |||
108954 | 15072 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1X Minerva St | 4 | Median : Cutout | Tree | DPW 1 | 6 | 11 | 5995966.88771 | 2089005.25507 | 37.7157795630524 | -122.45587684097 | (37.7157795630524, -122.45587684097) | 9 | 8 | 6 | 28861 | 24 | |||
103003 | 15076 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1 Minerva St | 2 | Median : Cutout | Tree | DPW 1 | 6 | 11 | 5995952.59829 | 2089005.63171 | 37.7157797770894 | -122.455926258705 | (37.7157797770894, -122.455926258705) | 9 | 8 | 6 | 28861 | 24 | |||
177439 | 15346 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1900 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6006752.3955 | 2107277.3553 | 37.7665637819511 | -122.419892925221 | (37.7665637819511, -122.419892925221) | 8 | 4 | 7 | 28853 | 19 | |||
146276 | 15348 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1905X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006806.3918 | 2107279.3589 | 37.7665723252126 | -122.419706303352 | (37.7665723252126, -122.419706303352) | 8 | 4 | 7 | 28853 | 19 | |||
57411 | 15349 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1906 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1993 12:00:00 AM | 12 | 4X4 | 6006754.9683 | 2107231.9019 | 37.7664391225711 | -122.419880800641 | (37.7664391225711, -122.419880800641) | 8 | 4 | 7 | 28853 | 19 | ||
91718 | 15351 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1911 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006804.043 | 2107232.3827 | 37.7664432073221 | -122.419711093977 | (37.7664432073221, -122.419711093977) | 8 | 4 | 7 | 28853 | 19 | |||
165918 | 15355 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1924 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006751.5378 | 2107181.3028 | 37.766299996101 | -122.41988907525 | (37.766299996101, -122.41988907525) | 8 | 4 | 7 | 28853 | 19 | |||
180632 | 15357 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1930 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6006758.13881 | 2107137.81381 | 37.7661809574571 | -122.419863157304 | (37.7661809574571, -122.419863157304) | 8 | 4 | 7 | 28853 | 19 | |||
24428 | 15360 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1939 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6006819.3103 | 2107093.8027 | 37.7660635592898 | -122.419648453627 | (37.7660635592898, -122.419648453627) | 8 | 4 | 7 | 28853 | 19 | |||
125776 | 15364 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1950X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6006764.6486243 | 2107014.2225799 | 37.7658419717714 | -122.419831870418 | (37.7658419717714, -122.419831870418) | 8 | 4 | 7 | 28853 | 19 | |||
182015 | 15367 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1950X Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006764.6486243 | 2107014.2225799 | 37.7658419717714 | -122.419831870418 | (37.7658419717714, -122.419831870418) | 8 | 4 | 7 | 28853 | 19 | |||
113475 | 15369 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1950X Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006764.6486243 | 2107014.2225799 | 37.7658419717714 | -122.419831870418 | (37.7658419717714, -122.419831870418) | 8 | 4 | 7 | 28853 | 19 | |||
150396 | 15373 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1979 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006845.42112 | 2106936.21263 | 37.7656323248047 | -122.419546959621 | (37.7656323248047, -122.419546959621) | 8 | 4 | 7 | 28853 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );