trees
2,180 rows where qSpecies_id = 57 sorted by Neighborhoods (old)
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 | ||||||||||||||
5324 | 177073 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 250 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6012250.9341 | 2087164.61689 | 37.7116466881279 | -122.399462161252 | (37.7116466881279, -122.399462161252) | 10 | 3 | 8 | 309 | 1 | |||
5567 | 6767 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1275 Fairfax Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1992 12:00:00 AM | 12 | 3x3 | 6017316.52552 | 2096883.88974 | 37.7386149694956 | -122.382629809543 | (37.7386149694956, -122.382629809543) | 10 | 3 | 8 | 58 | 1 | ||
10089 | 83062 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1375 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6016802.22624 | 2097268.63088 | 37.7396429656544 | -122.384434818109 | (37.7396429656544, -122.384434818109) | 10 | 3 | 8 | 58 | 1 | |||
12497 | 11955 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1469 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6015772.6789286 | 2096311.6012512 | 37.7369581722856 | -122.387927819023 | (37.7369581722856, -122.387927819023) | 10 | 3 | 8 | 58 | 1 | |||
14969 | 191498 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1198 La Salle Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | Width 4ft | 6016692.24365 | 2094766.72457 | 37.7327671503753 | -122.384640862701 | (37.7327671503753, -122.384640862701) | 10 | 3 | 8 | 58 | 1 | |||
18778 | 1705 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 70 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017900.5576644 | 2093604.0676713 | 37.729641471652 | -122.380382597634 | (37.729641471652, -122.380382597634) | 10 | 3 | 8 | 58 | 1 | |||
19574 | 261987 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1599x Armstrong Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014919 | 2092067 | 37.7252560234082 | -122.390582878929 | (37.7252560234082, -122.390582878929) | 10 | 3 | 8 | 58 | 1 | ||||
20725 | 12209 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1365X La Salle Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.384587939042 | (37.7327261850679, -122.384587939042) | 10 | 3 | 8 | 58 | 1 | |||
21555 | 200575 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1447 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6016348.7367 | 2095270.7725 | 37.7341321622018 | -122.385863584669 | (37.7341321622018, -122.385863584669) | 10 | 3 | 8 | 58 | 1 | |||
22254 | 199896 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1231 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6017188.7375 | 2093143.079 | 37.728336384515 | -122.382811392019 | (37.728336384515, -122.382811392019) | 10 | 3 | 8 | 58 | 1 | |||
23984 | 12171 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1421X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1993 12:00:00 AM | 9 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | ||
24245 | 12204 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1365X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.384587939042 | (37.7327261850679, -122.384587939042) | 10 | 3 | 8 | 58 | 1 | |||
25788 | 40954 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 117 Gillette Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41809 | 6013102.88048258 | 2086808.22702407 | 37.7107155607107 | -122.396492619427 | (37.7107155607107, -122.396492619427) | 10 | 3 | 8 | 309 | 1 | ||||
26949 | 12165 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1439X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | |||
31281 | 177081 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 299 Blanken Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6012270.95689 | 2087199.03401 | 37.711742306726 | -122.39939537131 | (37.711742306726, -122.39939537131) | 10 | 3 | 8 | 309 | 1 | |||
32141 | 177077 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 490 Blanken Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012777.25506 | 2087037.01969 | 37.7113256535156 | -122.397634098541 | (37.7113256535156, -122.397634098541) | 10 | 3 | 8 | 309 | 1 | |||
32436 | 104687 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 540 Blanken Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6013068.15068 | 2086901.5117 | 37.7109697693033 | -122.396619189338 | (37.7109697693033, -122.396619189338) | 10 | 3 | 8 | 309 | 1 | |||
33830 | 12207 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1365X La Salle Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.384587939042 | (37.7327261850679, -122.384587939042) | 10 | 3 | 8 | 58 | 1 | |||
34022 | 200058 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1801 Lane St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 0ft | 6014865.9446 | 2094065.6668 | 37.7307410182438 | -122.390905909596 | (37.7307410182438, -122.390905909596) | 10 | 3 | 8 | 58 | 1 | |||
35342 | 177087 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 201 Nueva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012854.22383 | 2086908.70499 | 37.7109776122888 | -122.397359080471 | (37.7109776122888, -122.397359080471) | 10 | 3 | 8 | 309 | 1 | |||
35708 | 177074 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 250 Blanken Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012293.95082 | 2087148.96015 | 37.7116060954047 | -122.399312384552 | (37.7116060954047, -122.399312384552) | 10 | 3 | 8 | 309 | 1 | |||
36498 | 191448 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1375 Fairfax Ave | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6016804.06254 | 2097268.13995 | 37.7396417192015 | -122.384428434726 | (37.7396417192015, -122.384428434726) | 10 | 3 | 8 | 58 | 1 | |||
37387 | 191496 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1198 La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6016644.61171 | 2094800.97865 | 37.7328585709492 | -122.384807925269 | (37.7328585709492, -122.384807925269) | 10 | 3 | 8 | 58 | 1 | |||
38133 | 177079 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 411 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012724.51952 | 2087052.83346 | 37.7113661383121 | -122.397817475721 | (37.7113661383121, -122.397817475721) | 10 | 3 | 8 | 309 | 1 | |||
39135 | 12169 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1425X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/16/1992 12:00:00 AM | 3 | 3X3 | 6016491.2755 | 2094964.9733 | 37.7333003856228 | -122.385349476433 | (37.7333003856228, -122.385349476433) | 10 | 3 | 8 | 58 | 1 | ||
39963 | 12206 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1365X La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.384587939042 | (37.7327261850679, -122.384587939042) | 10 | 3 | 8 | 58 | 1 | |||
40197 | 12213 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1503 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016014.681 | 2095761.1814 | 37.7354602343635 | -122.387052723732 | (37.7354602343635, -122.387052723732) | 10 | 3 | 8 | 58 | 1 | |||
43613 | 200620 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1417 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6016438.5299 | 2095044.7197 | 37.7335164350719 | -122.385537389897 | (37.7335164350719, -122.385537389897) | 10 | 3 | 8 | 58 | 1 | |||
49849 | 12198 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1485 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016165.7013657 | 2095622.0691082 | 37.7350866214264 | -122.386520887893 | (37.7350866214264, -122.386520887893) | 10 | 3 | 8 | 58 | 1 | |||
55059 | 191500 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1196 La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 3ft | 6016876.91408 | 2094649.78681 | 37.7324562736237 | -122.38399426454 | (37.7324562736237, -122.38399426454) | 10 | 3 | 8 | 58 | 1 | |||
56819 | 12120 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1325X La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016848.2078526 | 2094661.9057693 | 37.7324879628386 | -122.38409435335 | (37.7324879628386, -122.38409435335) | 10 | 3 | 8 | 58 | 1 | |||
58806 | 200576 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1447 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6016355.016 | 2095246.9114 | 37.7340669918878 | -122.385840212342 | (37.7340669918878, -122.385840212342) | 10 | 3 | 8 | 58 | 1 | |||
59284 | 191502 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 299x Cashmere St | 29 | Median : Yard | Tree | DPW 1 | 7 | 6016510.31046 | 2096089.32701 | 37.7363886887837 | -122.385361989469 | (37.7363886887837, -122.385361989469) | 10 | 3 | 8 | 58 | 1 | ||||
67213 | 177076 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 490 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012816.17748 | 2087024.55768 | 37.7112936025929 | -122.397498698426 | (37.7112936025929, -122.397498698426) | 10 | 3 | 8 | 309 | 1 | |||
67625 | 177080 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 411 Blanken Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012673.35079 | 2087069.8441 | 37.7114099964555 | -122.397995521673 | (37.7114099964555, -122.397995521673) | 10 | 3 | 8 | 309 | 1 | |||
69188 | 191446 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2 Tulare St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 6016252.95003 | 2100312.60959 | 37.7479707183947 | -122.386546192477 | (37.7479707183947, -122.386546192477) | 3 | 8 | 58 | 1 | |||||
69664 | 200695 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1603 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6015131.4073 | 2095732.6408 | 37.7353329178157 | -122.390104565626 | (37.7353329178157, -122.390104565626) | 10 | 3 | 8 | 58 | 1 | |||
70646 | 1696 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 34 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017739.6025757 | 2093657.002741 | 37.7297779384797 | -122.380942720777 | (37.7297779384797, -122.380942720777) | 10 | 3 | 8 | 58 | 1 | |||
71501 | 200524 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1475 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6016218.7564 | 2095580.3392 | 37.7349749763778 | -122.386334547429 | (37.7349749763778, -122.386334547429) | 10 | 3 | 8 | 58 | 1 | |||
71642 | 12182 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1447 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016313.573 | 2095416.4509 | 37.7345302198999 | -122.38599530928 | (37.7345302198999, -122.38599530928) | 10 | 3 | 8 | 58 | 1 | |||
71923 | 114790 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 100x GILLETTE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013060 | 2086881 | 37.7109129945759 | -122.39664592325 | (37.7109129945759, -122.39664592325) | 10 | 3 | 8 | 309 | 1 | ||||
75443 | 105174 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1601X NEWCOMB AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 40 | 3x3 | Permit Number 770204 | 6015135 | 2095759 | 37.7354054940815 | -122.390093985074 | (37.7354054940815, -122.390093985074) | 10 | 3 | 8 | 58 | 1 | ||
76187 | 191503 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 15 Baldwin Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6017915.59707 | 2093553.456 | 37.7295033317063 | -122.380327088241 | (37.7295033317063, -122.380327088241) | 10 | 3 | 8 | 58 | 1 | |||
76196 | 17144 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/1997 12:00:00 AM | 3 | 3X3 | 6017899.57967 | 2093362.52409 | 37.728978186084 | -122.380369198091 | (37.728978186084, -122.380369198091) | 10 | 3 | 8 | 58 | 1 | ||
78929 | 12184 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1445 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016331.1548 | 2095344.2396 | 37.7343329151573 | -122.385929490724 | (37.7343329151573, -122.385929490724) | 10 | 3 | 8 | 58 | 1 | |||
79516 | 12201 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1485 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3X3 | 6016149.0568 | 2095651.2946 | 37.7351659473192 | -122.386580471876 | (37.7351659473192, -122.386580471876) | 10 | 3 | 8 | 58 | 1 | |||
81093 | 12173 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1411X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1992 12:00:00 AM | 9 | 3X3 | 6016408.3895 | 2095102.4888 | 37.7336733897742 | -122.385645619675 | (37.7336733897742, -122.385645619675) | 10 | 3 | 8 | 58 | 1 | ||
86723 | 12188 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1457 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016282.8047 | 2095488.6622 | 37.7347267947864 | -122.386106718848 | (37.7347267947864, -122.386106718848) | 10 | 3 | 8 | 58 | 1 | |||
86899 | 54938 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 540 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/1972 12:00:00 AM | 14 | 4x3 | Permit Number 10816 | 6013051.42661 | 2086907.84409 | 37.7109862260136 | -122.396677435726 | (37.7109862260136, -122.396677435726) | 10 | 3 | 8 | 309 | 1 | |
92841 | 54939 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 537 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/1972 12:00:00 AM | 7 | Permit Number 10817 | 6013054.91789 | 2086947.83958 | 37.7110962400835 | -122.396668170907 | (37.7110962400835, -122.396668170907) | 10 | 3 | 8 | 309 | 1 | ||
94033 | 12170 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1421X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1993 12:00:00 AM | 9 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | ||
99533 | 191497 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1198 La Salle Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6016662.8976 | 2094787.97273 | 37.7328238706214 | -122.384743799985 | (37.7328238706214, -122.384743799985) | 10 | 3 | 8 | 58 | 1 | |||
101779 | 200578 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1423 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6016466.7865 | 2094992.602 | 37.7333748936582 | -122.385436067152 | (37.7333748936582, -122.385436067152) | 10 | 3 | 8 | 58 | 1 | |||
102592 | 17145 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1992 12:00:00 AM | 6 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.379831166827 | (37.7286870123052, -122.379831166827) | 10 | 3 | 8 | 58 | 1 | ||
103381 | 54754 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 525 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/1972 12:00:00 AM | 16 | Permit Number 10602 | 6013004.6612 | 2086964.21665 | 37.7111384110727 | -122.396843018889 | (37.7111384110727, -122.396843018889) | 10 | 3 | 8 | 309 | 1 | ||
106586 | 200061 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1801 Lane St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6014890.6772 | 2094101.3916 | 37.7308404836446 | -122.390822900138 | (37.7308404836446, -122.390822900138) | 10 | 3 | 8 | 58 | 1 | |||
110546 | 200621 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1421 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016453.6001 | 2095015.2073 | 37.7334362337312 | -122.38548323144 | (37.7334362337312, -122.38548323144) | 10 | 3 | 8 | 58 | 1 | |||
110667 | 191499 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1196 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 3ft | 6016833.73477 | 2094673.48546 | 37.7325189581847 | -122.38414519684 | (37.7325189581847, -122.38414519684) | 10 | 3 | 8 | 58 | 1 | |||
110902 | 177082 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 199 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012090.15374 | 2087257.68783 | 37.7118932795125 | -122.40002439672 | (37.7118932795125, -122.40002439672) | 10 | 3 | 8 | 309 | 1 | |||
119189 | 12183 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1445 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016331.0601118 | 2095306.4617143 | 37.7342291794135 | -122.385927185653 | (37.7342291794135, -122.385927185653) | 10 | 3 | 8 | 58 | 1 | |||
119266 | 12172 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1419X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | |||
119471 | 12118 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1325X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016848.2078526 | 2094661.9057693 | 37.7324879628386 | -122.38409435335 | (37.7324879628386, -122.38409435335) | 10 | 3 | 8 | 58 | 1 | |||
120292 | 191495 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1198 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6016624.88641 | 2094815.22838 | 37.7328966068827 | -122.384877113693 | (37.7328966068827, -122.384877113693) | 10 | 3 | 8 | 58 | 1 | |||
121804 | 191449 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1224 Fairfax Ave | 4 | : | Tree | Private 2 | 4 | Width 4ft | 6017403.85827 | 2096904.38167 | 37.7386760604628 | -122.382329276794 | (37.7386760604628, -122.382329276794) | 10 | 3 | 8 | 58 | 1 | |||
122469 | 40057 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1311 Shafter Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41291 | 6016435.57889801 | 2093012.13201176 | 37.7279351895138 | -122.385405998165 | (37.7279351895138, -122.385405998165) | 10 | 3 | 8 | 58 | 1 | ||
123193 | 191505 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1499 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6015798.08452 | 2096291.08713 | 37.7369032520929 | -122.387838548819 | (37.7369032520929, -122.387838548819) | 10 | 3 | 8 | 58 | 1 | |||
125806 | 6715 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1200X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
127679 | 177084 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 199 Blanken Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012033.75638 | 2087275.42031 | 37.7119388247963 | -122.400220567635 | (37.7119388247963, -122.400220567635) | 10 | 3 | 8 | 309 | 1 | |||
127774 | 6762 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1275 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2009 12:00:00 AM | 3 | 3x3 | 6017299.98506 | 2096895.81009 | 37.7386467866108 | -122.38268782839 | (37.7386467866108, -122.38268782839) | 10 | 3 | 8 | 58 | 1 | ||
129797 | 12186 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1455 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016291.5956 | 2095467.9407 | 37.7346703842439 | -122.38607488138 | (37.7346703842439, -122.38607488138) | 10 | 3 | 8 | 58 | 1 | |||
131753 | 191447 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300 Phelps St | 10 | : | Tree | Private 2 | 15 | Width 5ft | 6014017.68905 | 2096332.11237 | 37.7369171097253 | -122.393997082801 | (37.7369171097253, -122.393997082801) | 10 | 3 | 8 | 58 | 1 | |||
132147 | 12176 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1411X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | |||
133196 | 177083 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 199 Blanken Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012071.18023 | 2087265.13818 | 37.7119126788116 | -122.400090497793 | (37.7119126788116, -122.400090497793) | 10 | 3 | 8 | 309 | 1 | |||
133841 | 191504 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2 Baldwin Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6017862.18303 | 2093613.8535 | 37.7296662241092 | -122.38051594408 | (37.7296662241092, -122.38051594408) | 10 | 3 | 8 | 58 | 1 | |||
135876 | 17142 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1992 12:00:00 AM | 3 | 3X3 | 6017965.0245 | 2093314.70496 | 37.7288504949441 | -122.380139626367 | (37.7288504949441, -122.380139626367) | 10 | 3 | 8 | 58 | 1 | ||
136197 | 200625 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1431 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016504.462 | 2094945.5077 | 37.7332476664901 | -122.385302530701 | (37.7332476664901, -122.385302530701) | 10 | 3 | 8 | 58 | 1 | |||
143348 | 191501 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 299x Cashmere St | 2 | Median : Yard | Tree | DPW 1 | 27 | 6016915.88272 | 2095866.14342 | 37.7357983009387 | -122.383944206463 | (37.7357983009387, -122.383944206463) | 10 | 3 | 8 | 58 | 1 | ||||
149858 | 12178 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1409X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | |||
151018 | 12177 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1409X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | |||
155782 | 12166 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1439X La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | |||
155800 | 12179 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1405X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016402.1103 | 2095116.3031 | 37.733710973633 | -122.385668291381 | (37.733710973633, -122.385668291381) | 10 | 3 | 8 | 58 | 1 | |||
156338 | 200608 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1403 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016392.0635 | 2095142.048 | 37.7337811080514 | -122.385704820187 | (37.7337811080514, -122.385704820187) | 10 | 3 | 8 | 58 | 1 | |||
159386 | 177086 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 114 Gillette Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 6013074.44499 | 2086867.89295 | 37.7108778091238 | -122.396595079423 | (37.7108778091238, -122.396595079423) | 10 | 3 | 8 | 309 | 1 | |||
159405 | 1691 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 23 Baldwin Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017695.7876646 | 2093605.1145142 | 37.7296330451049 | -122.381090589205 | (37.7296330451049, -122.381090589205) | 10 | 3 | 8 | 58 | 1 | |||
160135 | 191494 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1198 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | Width 4ft | 6016613.84098 | 2094824.19976 | 37.7329206295756 | -122.384915925743 | (37.7329206295756, -122.384915925743) | 10 | 3 | 8 | 58 | 1 | |||
161788 | 12180 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1403X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | |||
163286 | 1687 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 15 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017775.00772 | 2093610.25153 | 37.729651522897 | -122.380817071263 | (37.729651522897, -122.380817071263) | 10 | 3 | 8 | 58 | 1 | ||
163827 | 12185 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1445 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016337.4341 | 2095323.5181 | 37.7342763655711 | -122.385906337047 | (37.7342763655711, -122.385906337047) | 10 | 3 | 8 | 58 | 1 | |||
164229 | 177072 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 140 Blanken Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012065.17517 | 2087224.72612 | 37.7118013805076 | -122.400108416784 | (37.7118013805076, -122.400108416784) | 10 | 3 | 8 | 309 | 1 | |||
166982 | 12187 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1455 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016297.2469 | 2095451.6147 | 37.7346258690942 | -122.386054205025 | (37.7346258690942, -122.386054205025) | 10 | 3 | 8 | 58 | 1 | |||
173645 | 177078 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 490 Blanken Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012757.34984 | 2087044.18122 | 37.7113442092312 | -122.397703398489 | (37.7113442092312, -122.397703398489) | 10 | 3 | 8 | 309 | 1 | |||
173917 | 177085 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 466 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6012392.66028 | 2086405.76084 | 37.7095709179289 | -122.398919087641 | (37.7095709179289, -122.398919087641) | 10 | 3 | 8 | 309 | 1 | |||
177429 | 1702 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 47 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017785.2431167 | 2093593.9655411 | 37.7296073696477 | -122.380780554369 | (37.7296073696477, -122.380780554369) | 10 | 3 | 8 | 58 | 1 | |||
178739 | 40056 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1311 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | 9 | Permit Number 41291 | 6016422.4594 | 2093017.6709 | 37.727949672355 | -122.385451738871 | (37.727949672355, -122.385451738871) | 10 | 3 | 8 | 58 | 1 | |
179739 | 200060 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1801 Lane St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 0ft | 6014881.3338 | 2094088.2009 | 37.7308037462249 | -122.390854280531 | (37.7308037462249, -122.390854280531) | 10 | 3 | 8 | 58 | 1 | |||
179786 | 6751 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1215 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1992 12:00:00 AM | 7 | 6017537.38126 | 2096718.538 | 37.7381731451641 | -122.381854690145 | (37.7381731451641, -122.381854690145) | 10 | 3 | 8 | 58 | 1 |
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) );