trees
2,180 rows where qSpecies_id = 57 sorted by Latitude
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 | ||||||||||||||
153953 | 177094 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Santa Barbara Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 5993369.32747 | 2086575.0773 | 37.7089574490044 | -122.464678768412 | (37.7089574490044, -122.464678768412) | 9 | 8 | 6 | 28861 | 25 | |||
173104 | 177093 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Santa Barbara Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 5993374.13741 | 2086578.2467 | 37.7089664287264 | -122.464662374692 | (37.7089664287264, -122.464662374692) | 9 | 8 | 6 | 28861 | 25 | |||
171634 | 177092 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Santa Barbara Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5993402.95207 | 2086595.08273 | 37.7090143176374 | -122.464564009531 | (37.7090143176374, -122.464564009531) | 9 | 8 | 6 | 28861 | 25 | |||
147397 | 177091 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Santa Barbara Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 5993412.52644 | 2086599.2418 | 37.7090262894008 | -122.464531221158 | (37.7090262894008, -122.464531221158) | 9 | 8 | 6 | 28861 | 25 | |||
44660 | 177090 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 36 Santa Cruz Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 5993074.95832 | 2086622.9468 | 37.7090719120225 | -122.46569961766 | (37.7090719120225, -122.46569961766) | 9 | 8 | 6 | 28861 | 25 | |||
74029 | 177088 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 300x Winding Way | 5 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6001504.62112 | 2086478.58914 | 37.7091581713864 | -122.436555171203 | (37.7091581713864, -122.436555171203) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
113480 | 177144 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 224 Naylor St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6002612.15992 | 2086733.11082 | 37.7099199079537 | -122.43274552071 | (37.7099199079537, -122.43274552071) | 9 | 7 | 6 | 28861 | 5 | |||
50331 | 177143 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 224 Naylor St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6002598.76646 | 2086748.83961 | 37.7099623361716 | -122.432792933869 | (37.7099623361716, -122.432792933869) | 9 | 7 | 6 | 28861 | 5 | |||
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 | ||||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |
180827 | 177075 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 601 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6013151.42883 | 2086913.13616 | 37.711006322265 | -122.396332172488 | (37.711006322265, -122.396332172488) | 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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
189254 | 31669 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 301 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1995 12:00:00 AM | Permit Number 35177 | 6012138.91947495 | 2087210.17556421 | 37.7117655390688 | -122.399852513423 | (37.7117655390688, -122.399852513423) | 10 | 3 | 8 | 309 | 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 | |||
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 | |||
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 | |||
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 | |||
57313 | 44826 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 129 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2001 12:00:00 AM | Permit Number 43918 | 6010308.29040288 | 2087358.77915196 | 37.7120713475932 | -122.406190163796 | (37.7120713475932, -122.406190163796) | 9 | 7 | 8 | 309 | 39 | |||
137745 | 207851 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 266 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994330.67336 | 2087784.23574 | 37.712332889716 | -122.461443843161 | (37.712332889716, -122.461443843161) | 9 | 8 | 6 | 28861 | 24 | |||
161982 | 177069 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 195 Allison St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6000083.89105 | 2087741.94761 | 37.7125462340909 | -122.441556016919 | (37.7125462340909, -122.441556016919) | 9 | 7 | 6 | 28861 | 5 | |||
107472 | 177070 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 195 Allison St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6000082.94652 | 2087742.95013 | 37.7125489329732 | -122.441559353395 | (37.7125489329732, -122.441559353395) | 9 | 7 | 6 | 28861 | 5 | |||
187018 | 177071 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 195 Allison St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6000082.85227 | 2087744.80295 | 37.7125540150319 | -122.441559812029 | (37.7125540150319, -122.441559812029) | 9 | 7 | 6 | 28861 | 5 | |||
37244 | 177142 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 417 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6002087.33741 | 2087757.61933 | 37.7127032044557 | -122.434632613123 | (37.7127032044557, -122.434632613123) | 9 | 7 | 6 | 28861 | 5 | |||
19806 | 117422 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 50 VERNON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992487 | 2088224 | 37.7134340885283 | -122.467848042178 | (37.7134340885283, -122.467848042178) | 9 | 8 | 6 | 64 | 24 | ||||
52506 | 207862 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 50 Vernon St | 2 | : | Tree | Private 2 | 13 | Width 3ft | 5992461.4298 | 2088225.86047 | 37.7134377203567 | -122.467936556254 | (37.7134377203567, -122.467936556254) | 9 | 8 | 6 | 64 | 24 | |||
9829 | 207861 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 70 Ralston St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5992207.07547 | 2088343.8619 | 37.7137470322778 | -122.468824268047 | (37.7137470322778, -122.468824268047) | 9 | 8 | 6 | 64 | 24 | |||
110484 | 207859 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 88 Ralston St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992207.50569 | 2088392.37957 | 37.713880274943 | -122.468826309486 | (37.713880274943, -122.468826309486) | 9 | 8 | 6 | 64 | 24 | |||
119782 | 207860 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 88 Ralston St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5992206.43527 | 2088409.02561 | 37.7139259191081 | -122.468831219804 | (37.7139259191081, -122.468831219804) | 9 | 8 | 6 | 64 | 24 | |||
66691 | 1139 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2627 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 1X1 | 5998352.02606 | 2088442.52333 | 37.7143710331717 | -122.447592253902 | (37.7143710331717, -122.447592253902) | 9 | 7 | 6 | 28861 | 25 | |||
173593 | 177068 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 26 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6000490.27056 | 2088504.66061 | 37.7146636177052 | -122.440206107549 | (37.7146636177052, -122.440206107549) | 9 | 7 | 6 | 28861 | 5 | |||
80889 | 1130 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2554 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5998598.10038 | 2088668.31183 | 37.7150050570134 | -122.446757963627 | (37.7150050570134, -122.446757963627) | 9 | 7 | 6 | 28861 | 25 | |||
160174 | 101866 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 851 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2013 12:00:00 AM | 2 | 3x3 | Permit Number 769709 | 6001077.03769 | 2088890.9773 | 37.7157577463948 | -122.438205662778 | (37.7157577463948, -122.438205662778) | 9 | 7 | 6 | 28861 | 5 | |
14971 | 26336 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2564 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5997739.39873 | 2089429.54745 | 37.7170461430363 | -122.449780813452 | (37.7170461430363, -122.449780813452) | 9 | 8 | 6 | 28861 | 24 | |||
190827 | 177041 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 36 Rome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 5999256.25941 | 2089431.5407 | 37.7171382857881 | -122.444537916099 | (37.7171382857881, -122.444537916099) | 9 | 7 | 6 | 28861 | 25 | |||
61147 | 177040 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 50 Rome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 5999261.05656 | 2089438.38497 | 37.7171573523208 | -122.444521826318 | (37.7171573523208, -122.444521826318) | 9 | 7 | 6 | 28861 | 25 | |||
15507 | 207853 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 258 Vernon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5992483.11623 | 2089580.88214 | 37.7171595349616 | -122.467960100499 | (37.7171595349616, -122.467960100499) | 9 | 8 | 6 | 64 | 24 | |||
82396 | 207854 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 258 Vernon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5992483.5365 | 2089596.1759 | 37.7172015521901 | -122.467959759631 | (37.7172015521901, -122.467959759631) | 9 | 8 | 6 | 64 | 24 | |||
144361 | 207850 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 277 Thrift St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 5994296.2066 | 2089616.42482 | 37.7173616620944 | -122.461695729788 | (37.7173616620944, -122.461695729788) | 9 | 8 | 6 | 28861 | 24 | |||
159325 | 65613 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 743 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1990 12:00:00 AM | 18 | Permit Number 28520 | 6001843.34769 | 2089618.06114 | 37.7177977109722 | -122.435608933303 | (37.7177977109722, -122.435608933303) | 9 | 7 | 6 | 28861 | 5 | |
51222 | 207848 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 833 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5995895.43899 | 2089793.88094 | 37.7179408434817 | -122.456180784842 | (37.7179408434817, -122.456180784842) | 9 | 8 | 6 | 28861 | 24 | |||
118234 | 19325 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 212 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X4 | 5993418.38204 | 2089852.67557 | 37.717959779598 | -122.464747082736 | (37.717959779598, -122.464747082736) | 9 | 8 | 6 | 64 | 24 | |||
122026 | 177089 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 545 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009804.5393 | 2089523.18108 | 37.7179861612047 | -122.408083826812 | (37.7179861612047, -122.408083826812) | 9 | 7 | 8 | 309 | 39 | |||
97197 | 52416 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 734 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/2005 12:00:00 AM | Permit Number 48535 | 6001832.35713287 | 2089688.63788093 | 37.717990874718 | -122.435651969168 | (37.717990874718, -122.435651969168) | 9 | 7 | 6 | 28861 | 5 | ||
36519 | 177044 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 87 Seneca Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 6000253.62595 | 2089858.96532 | 37.7183687570946 | -122.44112115244 | (37.7183687570946, -122.44112115244) | 9 | 7 | 6 | 28861 | 25 | |||
40533 | 177043 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 87 Seneca Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 6000241.05575 | 2089872.3479 | 37.7184047866172 | -122.441165561868 | (37.7184047866172, -122.441165561868) | 9 | 7 | 6 | 28861 | 25 | |||
152462 | 177042 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 123 Seneca Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 0ft | 6000059.76293 | 2090063.89794 | 37.7189204111404 | -122.441805953806 | (37.7189204111404, -122.441805953806) | 9 | 7 | 6 | 28861 | 25 | |||
140142 | 207849 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 48 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5995641.83079 | 2090207.60009 | 37.7190622575991 | -122.457087301461 | (37.7190622575991, -122.457087301461) | 9 | 8 | 6 | 28861 | 24 | |||
187349 | 67005 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 48 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30360 | 5995649.51069731 | 2090220.09677054 | 37.7190970115741 | -122.457061658607 | (37.7190970115741, -122.457061658607) | 9 | 8 | 6 | 28861 | 24 | ||
85430 | 177051 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998951.86154 | 2090168.3011 | 37.7191438872553 | -122.445643022832 | (37.7191438872553, -122.445643022832) | 9 | 7 | 6 | 28861 | 25 | |||
193006 | 62617 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 608 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/1986 12:00:00 AM | 7 | Permit Number 22927 | 6001463.88334 | 2090119.93819 | 37.719154192602 | -122.436956480181 | (37.719154192602, -122.436956480181) | 9 | 7 | 6 | 28861 | 5 | ||
181374 | 177052 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 Delano Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5998953.78777 | 2090172.93818 | 37.719156729587 | -122.445636697899 | (37.719156729587, -122.445636697899) | 9 | 7 | 6 | 28861 | 25 | |||
182503 | 177053 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 Delano Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5998955.22978 | 2090176.99773 | 37.719167958508 | -122.445632005212 | (37.719167958508, -122.445632005212) | 9 | 7 | 6 | 28861 | 25 | |||
122398 | 177054 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 Delano Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5998957.42918 | 2090181.03368 | 37.71917916587 | -122.44562469283 | (37.71917916587, -122.44562469283) | 9 | 7 | 6 | 28861 | 25 | |||
145161 | 177055 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 Delano Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998959.63131 | 2090185.20091 | 37.7191907338521 | -122.445617380444 | (37.7191907338521, -122.445617380444) | 9 | 7 | 6 | 28861 | 25 | |||
51228 | 177056 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 Delano Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5998961.55007 | 2090188.45269 | 37.71919977204 | -122.445610981758 | (37.71919977204, -122.445610981758) | 9 | 7 | 6 | 28861 | 25 | |||
100754 | 177057 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 Delano Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5998963.19339 | 2090191.18353 | 37.7192073641203 | -122.445605497718 | (37.7192073641203, -122.445605497718) | 9 | 7 | 6 | 28861 | 25 | |||
168982 | 177058 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 Delano Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5998964.8504 | 2090194.57209 | 37.7192167629302 | -122.445600013628 | (37.7192167629302, -122.445600013628) | 9 | 7 | 6 | 28861 | 25 | |||
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 | ||||
193271 | 177064 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 102 France Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 1ft | 6001373.70465 | 2090220.37665 | 37.7194248480604 | -122.437275380676 | (37.7194248480604, -122.437275380676) | 9 | 7 | 6 | 28861 | 5 | |||
193998 | 207855 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 494 Victoria St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993274.09777 | 2090428.40721 | 37.719532280163 | -122.465287603161 | (37.719532280163, -122.465287603161) | 9 | 8 | 6 | 64 | 24 | |||
57591 | 207856 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 494 Victoria St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993273.29613 | 2090436.09778 | 37.7195533503791 | -122.465290932448 | (37.7195533503791, -122.465290932448) | 9 | 8 | 6 | 64 | 24 | |||
76280 | 177065 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 626 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6002192.98275 | 2090253.20784 | 37.7195615351173 | -122.434445788846 | (37.7195615351173, -122.434445788846) | 9 | 7 | 6 | 28861 | 5 | |||
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 | ||||
115045 | 207857 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 494 Victoria St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 5993273.27728 | 2090450.48631 | 37.7195928567171 | -122.465292042207 | (37.7195928567171, -122.465292042207) | 9 | 8 | 6 | 64 | 24 | |||
162954 | 207858 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 143 Garfield St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993571.00568 | 2090460.55199 | 37.7196376600192 | -122.464263641377 | (37.7196376600192, -122.464263641377) | 9 | 8 | 6 | 64 | 24 | |||
43775 | 177066 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 573 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6002664.89947 | 2090416.35383 | 37.7200362746301 | -122.432826194382 | (37.7200362746301, -122.432826194382) | 9 | 7 | 6 | 28861 | 5 | |||
130926 | 177067 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 573 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6002673.20995 | 2090427.02699 | 37.7200660520992 | -122.432798229977 | (37.7200660520992, -122.432798229977) | 9 | 7 | 6 | 28861 | 5 | |||
185308 | 65177 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 573 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1989 12:00:00 AM | Permit Number 27158 | 6002678.99460756 | 2090431.51316854 | 37.7200786982312 | -122.43277855471 | (37.7200786982312, -122.43277855471) | 9 | 7 | 6 | 28861 | 5 | ||
169353 | 207847 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 400 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995588.09543 | 2090580.79577 | 37.7200838784522 | -122.457300026187 | (37.7200838784522, -122.457300026187) | 9 | 8 | 6 | 28861 | 24 | |||
122227 | 67018 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 400 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30374 | 5995620.26197767 | 2090586.55623665 | 37.7201015427641 | -122.457189254526 | (37.7201015427641, -122.457189254526) | 9 | 8 | 6 | 28861 | 24 | ||
173064 | 67985 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 212 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31709 | 5996176.45016211 | 2090576.83582112 | 37.7201067800111 | -122.455266009291 | (37.7201067800111, -122.455266009291) | 9 | 8 | 6 | 28861 | 24 | ||
80623 | 177063 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 550 Geneva Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5999015.35979 | 2090528.72065 | 37.7201371416945 | -122.445449436536 | (37.7201371416945, -122.445449436536) | 9 | 7 | 6 | 28861 | 25 | |||
110964 | 177062 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 550 Geneva Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5999011.63296 | 2090530.40369 | 37.7201415501799 | -122.445462439842 | (37.7201415501799, -122.445462439842) | 9 | 7 | 6 | 28861 | 25 | |||
78388 | 177061 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 550 Geneva Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 5999007.90612 | 2090532.0864 | 37.7201459577571 | -122.44547544316 | (37.7201459577571, -122.44547544316) | 9 | 7 | 6 | 28861 | 25 | |||
104597 | 177060 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 550 Geneva Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5999004.71102 | 2090533.49079 | 37.7201496314864 | -122.445486588437 | (37.7201496314864, -122.445486588437) | 9 | 7 | 6 | 28861 | 25 | |||
110031 | 177059 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 550 Geneva Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5999000.98419 | 2090535.17383 | 37.7201540399677 | -122.445499591747 | (37.7201540399677, -122.445499591747) | 9 | 7 | 6 | 28861 | 25 | |||
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 | ||||
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 | ||||
148097 | 207845 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 125 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5995607.33872 | 2090657.41082 | 37.7202953504384 | -122.457239048555 | (37.7202953504384, -122.457239048555) | 9 | 8 | 6 | 28861 | 24 | |||
31714 | 67465 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 937 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1992 12:00:00 AM | 9 | Permit Number 30978 | 6008961.1272 | 2090382.77007 | 37.7202991536555 | -122.41105982826 | (37.7202991536555, -122.41105982826) | 9 | 3 | 7 | 309 | 28 | ||
160277 | 207841 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 314 Faxon Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5994779.70633 | 2090681.15374 | 37.7203129744452 | -122.460101600536 | (37.7203129744452, -122.460101600536) | 9 | 8 | 6 | 28861 | 24 | |||
76695 | 207840 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 314 Faxon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5994777.11096 | 2090681.20811 | 37.7203129744533 | -122.460110575752 | (37.7203129744533, -122.460110575752) | 9 | 8 | 6 | 28861 | 24 |
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) );