trees
2,180 rows where qSpecies_id = 57 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6273 | 173900 | Private 9 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
10205 | 173902 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
11334 | 51578 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2005 12:00:00 AM | Permit Number 47872 | ||||||||||||||
14524 | 99746 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 4250 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | ||||||||||||||
160140 | 67262 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 511 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | 6 | Permit Number 30729 | 5981280.93302 | 2112230.5095 | 37.7786957851972 | -122.508360365452 | (37.7786957851972, -122.508360365452) | 11 | 6 | 2 | 55 | 26 | |
50151 | 67223 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 555 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1992 12:00:00 AM | 6 | Permit Number 30682 | 5981290.9854 | 2111950.9362 | 37.7779287520405 | -122.508304833393 | (37.7779287520405, -122.508304833393) | 11 | 6 | 2 | 55 | 26 | |
39465 | 67244 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 5524 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | 7 | Permit Number 30708 | 5981494.88729 | 2111682.33433 | 37.7772032645806 | -122.507579541736 | (37.7772032645806, -122.507579541736) | 11 | 6 | 2 | 55 | 26 | |
129378 | 46972 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1686 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/2002 12:00:00 AM | 2 | Permit Number 44991 | 5982549.0126 | 2103652.333 | 37.755217228082 | -122.50333832645 | (37.755217228082, -122.50333832645) | 1 | 8 | 3 | 56 | 35 | |
124680 | 46971 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1686 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/2002 12:00:00 AM | 2 | Permit Number 44991 | 5982549.6238 | 2103640.11 | 37.7551837030962 | -122.50333530778 | (37.7551837030962, -122.50333530778) | 1 | 8 | 3 | 56 | 35 | |
79170 | 183298 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1286 42nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5983077.483 | 2106384.7622 | 37.7627507593691 | -122.501712895715 | (37.7627507593691, -122.501712895715) | 1 | 8 | 3 | 56 | 35 | |||
139627 | 183299 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1286 42nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5983077.483 | 2106392.3859 | 37.7627716918826 | -122.501713459776 | (37.7627716918826, -122.501713459776) | 1 | 8 | 3 | 56 | 35 | |||
110045 | 183625 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1431 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5983375.6866 | 2105398.8736 | 37.7600612994594 | -122.500608628087 | (37.7600612994594, -122.500608628087) | 1 | 8 | 3 | 56 | 35 | |||
47328 | 184122 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3340 Lawton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5983807.3681 | 2104294.0393 | 37.7570530669968 | -122.49903404016 | (37.7570530669968, -122.49903404016) | 1 | 8 | 3 | 56 | 35 | |||
76339 | 100230 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 701X 39th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5983807.86909 | 2110960.60417 | 37.7753575879766 | -122.499524975598 | (37.7753575879766, -122.499524975598) | 11 | 6 | 2 | 55 | 26 | |||
182535 | 100232 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 701X 39th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5983809.61939 | 2110917.38856 | 37.7752390330911 | -122.499515726535 | (37.7752390330911, -122.499515726535) | 11 | 6 | 2 | 55 | 26 | |||
7648 | 62594 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 735 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 9 | Permit Number 22900 | 5984433.86075 | 2110817.89863 | 37.7750024687546 | -122.497349020618 | (37.7750024687546, -122.497349020618) | 11 | 6 | 2 | 55 | 26 | |
7160 | 62593 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 731 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 9 | Permit Number 22899 | 5984434.98291 | 2110845.23688 | 37.7750775975018 | -122.497347157504 | (37.7750775975018, -122.497347157504) | 11 | 6 | 2 | 55 | 26 | |
10883 | 62592 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 763 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | Permit Number 22898 | 5984437.65774708 | 2110651.26442232 | 37.7745451616246 | -122.497323582278 | (37.7745451616246, -122.497323582278) | 11 | 6 | 2 | 55 | 26 | ||
9420 | 62591 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 759 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 9 | Permit Number 22897 | 5984439.68457 | 2110661.64848 | 37.7745737920548 | -122.497317337939 | (37.7745737920548, -122.497317337939) | 11 | 6 | 2 | 55 | 26 | |
31607 | 118275 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 763 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5984440.01732 | 2110639.37608 | 37.7745126579414 | -122.497314542381 | (37.7745126579414, -122.497314542381) | 11 | 6 | 2 | 55 | 26 | |||
918 | 62597 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 7 | Permit Number 22903 | 5984441.0146 | 2110622.99108 | 37.7744677278845 | -122.497309882833 | (37.7744677278845, -122.497309882833) | 11 | 6 | 2 | 55 | 26 | |
120222 | 118272 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 801 37th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 5984451.19382 | 2110333.53689 | 37.7736735662944 | -122.497253299741 | (37.7736735662944, -122.497253299741) | 11 | 6 | 2 | 55 | 26 | |||
192535 | 54531 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 855 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1972 12:00:00 AM | 12 | Permit Number 10326 | 5984466.31691 | 2110015.99536 | 37.7728025745037 | -122.497177542996 | (37.7728025745037, -122.497177542996) | 11 | 6 | 2 | 55 | 26 | ||
10932 | 185624 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100 Sunset Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985032.5384 | 2100289.574 | 37.7461296959342 | -122.494501805094 | (37.7461296959342, -122.494501805094) | 1 | 8 | 3 | 29491 | 35 | |||
37287 | 118089 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 7049 Geary Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 1ft | 5985075.84275 | 2112426.03783 | 37.7794555626476 | -122.495246917032 | (37.7794555626476, -122.495246917032) | 11 | 6 | 2 | 55 | 26 | |||
165770 | 186910 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2700 Sunset Blvd | 59 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985181.9251 | 2096700.884 | 37.7362848611965 | -122.49372085207 | (37.7362848611965, -122.49372085207) | 1 | 8 | 3 | 29491 | 35 | |||
87418 | 256350 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3000X Sunset Blvd | 29 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
149901 | 256348 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3000X Sunset Blvd | 27 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
193853 | 256349 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3000X Sunset Blvd | 28 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
69523 | 182830 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1811 34th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5985639.2314 | 2102838.2271 | 37.7531630922797 | -122.492591636324 | (37.7531630922797, -122.492591636324) | 1 | 8 | 3 | 56 | 35 | |||
70400 | 182848 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1795 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5985939.7457 | 2103040.5574 | 37.7537362025059 | -122.491567304651 | (37.7537362025059, -122.491567304651) | 1 | 8 | 3 | 56 | 35 | |||
155993 | 119447 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 895 32nd Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5986012.28825 | 2109834.94123 | 37.7723959307274 | -122.491816595906 | (37.7723959307274, -122.491816595906) | 11 | 6 | 2 | 55 | 26 | ||||
158628 | 37203 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1574 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 5 | Permit Number 39770 | 5986243.4033 | 2104539.0139 | 37.7578682946863 | -122.490627442767 | (37.7578682946863, -122.490627442767) | 1 | 8 | 3 | 56 | 35 | |
120881 | 119507 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 725 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5986293.69452 | 2110943.52758 | 37.7754562387381 | -122.490924788931 | (37.7754562387381, -122.490924788931) | 11 | 6 | 2 | 55 | 26 | |||
146310 | 119942 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 346 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5986553.23014 | 2113597.32948 | 37.7827579817147 | -122.490222261455 | (37.7827579817147, -122.490222261455) | 11 | 6 | 2 | 55 | 26 | |||
71627 | 185606 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2123 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5987259.0828 | 2100808.0996 | 37.7476834885004 | -122.486840869567 | (37.7476834885004, -122.486840869567) | 1 | 8 | 3 | 29491 | 35 | |||
153318 | 114098 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 219x VIDAL DR | 1 | Front Yard : Cutout | Tree | Private 2 | 40 | 5987664 | 2090565 | 37.7195822022131 | -122.484689437364 | (37.7195822022131, -122.484689437364) | 1 | 8 | 4 | 64 | 14 | ||||
58321 | 114094 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 239x VIDAL DR | 1 | Front Yard : Yard | Tree | Private 2 | 24 | 5987668 | 2090475 | 37.7193353179991 | -122.484669012602 | (37.7193353179991, -122.484669012602) | 1 | 8 | 4 | 64 | 14 | ||||
70557 | 120187 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 218 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5987760.31768 | 2114496.30361 | 37.7852967290916 | -122.486112314519 | (37.7852967290916, -122.486112314519) | 11 | 6 | 2 | 55 | 26 | |||
26786 | 59149 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 218 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1980 12:00:00 AM | 7 | Permit Number 18458 | 5987761.12595 | 2114471.82373 | 37.7852295614332 | -122.486107720545 | (37.7852295614332, -122.486107720545) | 11 | 6 | 2 | 55 | 26 | ||
93630 | 101635 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1800X 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5987855.0174 | 2102962.611 | 37.7536339253443 | -122.484938226474 | (37.7536339253443, -122.484938226474) | 1 | 8 | 3 | 56 | 35 | |||
54413 | 55257 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 810 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/1972 12:00:00 AM | 5 | Permit Number 11179 | 5988221.44369 | 2110421.88962 | 37.7741363990758 | -122.484218064948 | (37.7741363990758, -122.484218064948) | 11 | 6 | 2 | 55 | 26 | ||
73875 | 120484 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2309 Lake St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 1ft | 5988270.49901 | 2114625.30582 | 37.7856806525103 | -122.484356728893 | (37.7856806525103, -122.484356728893) | 11 | 6 | 2 | 55 | 26 | |||
92012 | 182589 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2483 26th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5988272.3462 | 2098420.0243 | 37.741185487105 | -122.483162087393 | (37.741185487105, -122.483162087393) | 1 | 8 | 3 | 29491 | 35 | |||
96714 | 120483 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2309 Lake St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 5988277.53401 | 2114625.15663 | 37.7856806525102 | -122.484332379162 | (37.7856806525102, -122.484332379162) | 11 | 6 | 2 | 55 | 26 | |||
185329 | 120302 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 361 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5988369.83373 | 2113569.61422 | 37.7827878063085 | -122.483935624743 | (37.7827878063085, -122.483935624743) | 11 | 6 | 2 | 55 | 26 | |||
63511 | 12823 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2201 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | 3 | 5 | 5988577.51702 | 2114639.82314 | 37.7857383852899 | -122.483295611932 | (37.7857383852899, -122.483295611932) | 11 | 6 | 2 | 55 | 26 | ||
116449 | 183926 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1595 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5988583.1369 | 2101004.688 | 37.7483003735732 | -122.482276819356 | (37.7483003735732, -122.482276819356) | 1 | 8 | 3 | 29491 | 35 | |||
37426 | 120482 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2201 Lake St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 1ft | 5988588.08717 | 2114640.40789 | 37.7857406059941 | -122.483259085533 | (37.7857406059941, -122.483259085533) | 11 | 6 | 2 | 55 | 26 | |||
168790 | 120481 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2201 Lake St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 1ft | 5988593.25091 | 2114641.37666 | 37.7857435664695 | -122.483241291711 | (37.7857435664695, -122.483241291711) | 11 | 6 | 2 | 55 | 26 | |||
193796 | 120479 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2201 Lake St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 5988612.47401 | 2114641.5086 | 37.785745047419 | -122.483174795713 | (37.785745047419, -122.483174795713) | 11 | 6 | 2 | 55 | 26 | |||
63003 | 120478 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2201 Lake St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 5988614.91495 | 2114641.72629 | 37.7857457871807 | -122.483166366817 | (37.7857457871807, -122.483166366817) | 11 | 6 | 2 | 55 | 26 | |||
6482 | 120477 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2201 Lake St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 1ft | 5988623.03819 | 2114641.82381 | 37.785746527658 | -122.483138270198 | (37.785746527658, -122.483138270198) | 11 | 6 | 2 | 55 | 26 | |||
37558 | 120397 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 101 23rd Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 1ft | 5988633.13859 | 2114628.42785 | 37.7857103339154 | -122.483102343869 | (37.7857103339154, -122.483102343869) | 11 | 6 | 2 | 55 | 26 | |||
64413 | 120396 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 101 23rd Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 1ft | 5988633.9259 | 2114634.88666 | 37.7857281137897 | -122.483100093611 | (37.7857281137897, -122.483100093611) | 11 | 6 | 2 | 55 | 26 | |||
70224 | 120400 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 163 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5988653.91402 | 2114240.51561 | 37.7846464457785 | -122.483002026322 | (37.7846464457785, -122.483002026322) | 11 | 6 | 2 | 55 | 26 | |||
148570 | 183930 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1595 Quintara St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5988704.6498 | 2101009.2638 | 37.748320004874 | -122.481856971083 | (37.748320004874, -122.481856971083) | 1 | 8 | 3 | 29491 | 35 | |||
129359 | 183931 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1595 Quintara St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5988739.7309 | 2101009.2638 | 37.7483220449634 | -122.481735662973 | (37.7483220449634, -122.481735662973) | 1 | 8 | 3 | 29491 | 35 | |||
109676 | 101109 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1790 24th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | Permit Number 14067 | 5988776.9552 | 2103216.747 | 37.7543853705337 | -122.481768612291 | (37.7543853705337, -122.481768612291) | 1 | 8 | 3 | 56 | 35 | ||
94756 | 101108 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1790 24th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3X3 | Permit Number 14067 | 5988777.5028 | 2103198.1315 | 37.7543342891997 | -122.481765355128 | (37.7543342891997, -122.481765355128) | 1 | 8 | 3 | 56 | 35 | ||
69917 | 101107 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1790 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3X3 | Permit Number 14067 | 5988779.1453 | 2103160.9003 | 37.7542321578078 | -122.481756948123 | (37.7542321578078, -122.481756948123) | 1 | 8 | 3 | 56 | 35 | ||
101926 | 56836 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1790 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | 2 | 3X3 | Permit Number 14067 | 5988782.4304 | 2103136.262 | 37.7541646986668 | -122.481743783017 | (37.7541646986668, -122.481743783017) | 1 | 8 | 3 | 56 | 35 | |
110802 | 101266 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2126 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989175 | 2106519 | 37.7634756077712 | -122.480633814056 | (37.7634756077712, -122.480633814056) | 1 | 8 | 3 | 56 | 35 | ||||
117442 | 101265 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2034 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989459.10715 | 2106523.86109 | 37.7635054630097 | -122.47965154526 | (37.7635054630097, -122.47965154526) | 1 | 8 | 3 | 56 | 35 | ||||
74377 | 177096 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | 5989524.60255 | 2090740.45181 | 37.7201721325212 | -122.478270901482 | (37.7201721325212, -122.478270901482) | 1 | 8 | 4 | 64 | 14 | ||||
1783 | 61503 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 174 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/1986 12:00:00 AM | 8 | Permit Number 23383 | 5989631.93083 | 2114222.6944 | 37.7846543745532 | -122.479617149177 | (37.7846543745532, -122.479617149177) | 11 | 6 | 2 | 55 | 26 | |
134830 | 177095 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 48 | 5989637.49515 | 2090738.06528 | 37.720172132515 | -122.47788049948 | (37.720172132515, -122.47788049948) | 1 | 8 | 4 | 64 | 14 | ||||
93597 | 182701 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1706 21st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5989689.5329 | 2103706.6241 | 37.7557834692143 | -122.478648542868 | (37.7557834692143, -122.478648542868) | 1 | 8 | 3 | 56 | 35 | |||
191231 | 101261 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1945 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989742 | 2106485 | 37.7634151902649 | -122.478670277794 | (37.7634151902649, -122.478670277794) | 1 | 8 | 3 | 56 | 35 | ||||
49140 | 56420 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 231 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1973 12:00:00 AM | 7 | Permit Number 12580 | 5990219.56418 | 2113818.46401 | 37.7835785885278 | -122.477554600218 | (37.7835785885278, -122.477554600218) | 11 | 6 | 2 | 55 | 26 | ||
70941 | 56417 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 222 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1973 12:00:00 AM | 10 | Permit Number 12577 | 5990267.02613 | 2113888.22786 | 37.783772894624 | -122.477395502293 | (37.783772894624, -122.477395502293) | 11 | 6 | 2 | 55 | 26 | ||
143832 | 56418 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 226 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1973 12:00:00 AM | 9 | Permit Number 12578 | 5990267.28978 | 2113858.89022 | 37.7836923569542 | -122.477392445306 | (37.7836923569542, -122.477392445306) | 11 | 6 | 2 | 55 | 26 | ||
60017 | 40560 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 458 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1999 12:00:00 AM | 7 | Permit Number 41604 | 5990324.44539 | 2112242.31069 | 37.779256995112 | -122.477076541974 | (37.779256995112, -122.477076541974) | 11 | 6 | 2 | 55 | 26 | |
183786 | 122271 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1600 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5990587.5386 | 2111332.78753 | 37.7767749549722 | -122.476099955577 | (37.7767749549722, -122.476099955577) | 11 | 6 | 2 | 55 | 26 | |||
169632 | 122270 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1600 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5990596.49847 | 2111330.48766 | 37.7767691597055 | -122.47606879302 | (37.7767691597055, -122.47606879302) | 11 | 6 | 2 | 55 | 26 | |||
159278 | 207892 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2119 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5990666.05125 | 2100929.33737 | 37.7482144184726 | -122.475068731353 | (37.7482144184726, -122.475068731353) | 1 | 8 | 4 | 29491 | 40 | |||
63681 | 67388 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 779 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1992 12:00:00 AM | 12 | Permit Number 30885 | 5990666.23465 | 2110099.72843 | 37.7733938754744 | -122.475737660544 | (37.7733938754744, -122.475737660544) | 11 | 6 | 2 | 55 | 26 | |
151945 | 34242 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1263 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/1997 12:00:00 AM | Permit Number 38052 | 5990773.84225381 | 2106807.51859079 | 37.7643605962692 | -122.475125051391 | (37.7643605962692, -122.475125051391) | 11 | 8 | 3 | 56 | 12 | |||
176929 | 55004 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 585 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 9 | Permit Number 10882 | 5990928.49024 | 2111392.95682 | 37.7769599278948 | -122.474924907094 | (37.7769599278948, -122.474924907094) | 11 | 6 | 2 | 54 | 26 | ||
129019 | 122095 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 585 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5990929.30413 | 2111377.25898 | 37.776916873099 | -122.474920945501 | (37.776916873099, -122.474920945501) | 11 | 6 | 2 | 54 | 26 | |||
52043 | 56174 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 701 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/1973 12:00:00 AM | 9 | Permit Number 12282 | 5990956.32694 | 2110582.1012 | 37.7747351534663 | -122.474769414984 | (37.7747351534663, -122.474769414984) | 11 | 6 | 2 | 54 | 26 | ||
182830 | 122093 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 701 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990957.61701 | 2110561.83136 | 37.7746795727782 | -122.474763472642 | (37.7746795727782, -122.474763472642) | 11 | 6 | 2 | 54 | 26 | |||
62968 | 55001 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 546 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 12 | Permit Number 10879 | 5990967.23553 | 2111663.9992 | 37.7777063811552 | -122.474810664746 | (37.7777063811552, -122.474810664746) | 11 | 6 | 2 | 54 | 26 | ||
135944 | 56173 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 680 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/1973 12:00:00 AM | 9 | Permit Number 12281 | 5990998.5556 | 2110774.78809 | 37.7752666659576 | -122.474637404879 | (37.7752666659576, -122.474637404879) | 11 | 6 | 2 | 54 | 26 | ||
26834 | 122133 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 5991114.06572 | 2115007.37065 | 37.7868948615896 | -122.474546795399 | (37.7868948615896, -122.474546795399) | 11 | 6 | 1 | 54 | 33 | ||||
74409 | 122131 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5991115.12021 | 2115013.7594 | 37.7869124644121 | -122.47454361357 | (37.7869124644121, -122.47454361357) | 11 | 6 | 1 | 54 | 33 | ||||
100229 | 122130 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 5991115.18782 | 2115016.96334 | 37.7869212654547 | -122.474543613569 | (37.7869212654547, -122.474543613569) | 11 | 6 | 1 | 54 | 33 | ||||
42013 | 122135 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 5991115.45698 | 2114997.03818 | 37.78686657212 | -122.474541227661 | (37.78686657212, -122.474541227661) | 11 | 6 | 1 | 54 | 33 | ||||
181449 | 122137 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 5991115.84231 | 2114982.60549 | 37.786826966306 | -122.47453884083 | (37.786826966306, -122.47453884083) | 11 | 6 | 1 | 54 | 33 | ||||
109978 | 122132 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5991115.98152 | 2115010.99351 | 37.7869049199545 | -122.474540431734 | (37.7869049199545, -122.474540431734) | 11 | 6 | 1 | 54 | 33 | ||||
112069 | 122139 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5991116.38675 | 2114975.72508 | 37.7868081061645 | -122.474536454895 | (37.7868081061645, -122.474536454895) | 11 | 6 | 1 | 54 | 33 | ||||
26550 | 122134 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5991116.74625 | 2115003.65081 | 37.7868848032576 | -122.4745372499 | (37.7868848032576, -122.4745372499) | 11 | 6 | 1 | 54 | 33 | ||||
23570 | 122138 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5991116.91399 | 2114978.91933 | 37.7868169072323 | -122.474534863989 | (37.7868169072323, -122.474534863989) | 11 | 6 | 1 | 54 | 33 | ||||
119438 | 122136 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5991117.00305 | 2114994.02901 | 37.7868583993583 | -122.47453565898 | (37.7868583993583, -122.47453565898) | 11 | 6 | 1 | 54 | 33 | ||||
171591 | 207863 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 40 Lagunitas Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5991134.49125 | 2095574.87688 | 37.7335395798715 | -122.47305847768 | (37.7335395798715, -122.47305847768) | 1 | 8 | 4 | 64 | 40 | |||
151518 | 207864 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2545 Ocean Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5991142.22279 | 2094819.87718 | 37.7314669887904 | -122.472976710428 | (37.7314669887904, -122.472976710428) | 1 | 8 | 4 | 64 | 40 | |||
102984 | 102084 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 201 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52515 | 5991161.35766 | 2114023.19945 | 37.7841953413 | -122.474311334384 | (37.7841953413, -122.474311334384) | 11 | 6 | 2 | 54 | 26 |
188651 | 121996 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 626 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5991310.91563 | 2111122.21398 | 37.7762386968182 | -122.473582239238 | (37.7762386968182, -122.473582239238) | 11 | 6 | 2 | 54 | 26 | |||
126291 | 121997 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 634 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5991314.5458 | 2111079.72567 | 37.7761222457547 | -122.473566581625 | (37.7761222457547, -122.473566581625) | 11 | 6 | 2 | 54 | 26 | |||
42807 | 207398 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 160 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5991337.5246 | 2104227.06806 | 37.7573080176715 | -122.472987263976 | (37.7573080176715, -122.472987263976) | 1 | 8 | 4 | 56 | 12 |
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) );