trees
2,180 rows where qSpecies_id = 57 sorted by TreeID
This data as json, CSV (advanced)
rowid | TreeID ▼ | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
80424 | 110186 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 625 Holly Park Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6006167.62160945 | 2096413.49051844 | 37.7367011423593 | -122.421144072665 | (37.7367011423593, -122.421144072665) | 2 | 7 | 7 | 28859 | 2 | ||||
92761 | 110187 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 625 Holly Park Cir | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6006167.62160945 | 2096413.49051844 | 37.7367011423593 | -122.421144072665 | (37.7367011423593, -122.421144072665) | 2 | 7 | 7 | 28859 | 2 | |||||
143802 | 110189 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 625 Holly Park Cir | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6006167.62160945 | 2096413.49051844 | 37.7367011423593 | -122.421144072665 | (37.7367011423593, -122.421144072665) | 2 | 7 | 7 | 28859 | 2 | ||||
91360 | 110190 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 625 Holly Park Cir | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6006167.62160945 | 2096413.49051844 | 37.7367011423593 | -122.421144072665 | (37.7367011423593, -122.421144072665) | 2 | 7 | 7 | 28859 | 2 | |||||
31107 | 111019 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 90x DOWNEY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2015 12:00:00 AM | 3x3 | 5998894 | 2107683 | 37.7672317271747 | -122.447102814384 | (37.7672317271747, -122.447102814384) | 15 | 5 | 11 | 29492 | 9 | |||
90014 | 111067 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1800 10TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993175 | 2103134 | 37.7544129453028 | -122.466553158269 | (37.7544129453028, -122.466553158269) | 1 | 8 | 4 | 56 | 12 | ||||
186317 | 111081 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2811 14TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992341 | 2097126 | 37.7378683540452 | -122.469000113007 | (37.7378683540452, -122.469000113007) | 1 | 8 | 4 | 59 | 40 | ||||
66593 | 112141 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 299 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6011568.52353 | 2112270.39261 | 37.7805436673854 | -122.403586031292 | (37.7805436673854, -122.403586031292) | 6 | 2 | 9 | 28853 | 34 | |||
43925 | 112146 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 299X 05TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6011616 | 2112272 | 37.7805507327562 | -122.403421899857 | (37.7805507327562, -122.403421899857) | 6 | 2 | 9 | 28853 | 34 | |||
92435 | 112343 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 28 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993108 | 2098132 | 37.7406748633007 | -122.466421337063 | (37.7406748633007, -122.466421337063) | 1 | 8 | 4 | 59 | 40 | ||||
81604 | 112350 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 130 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992742 | 2097684 | 37.7394236424672 | -122.46765424156 | (37.7394236424672, -122.46765424156) | 1 | 8 | 4 | 59 | 40 | ||||
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 | |||
68964 | 113434 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198x HIGHLAND AVE | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12 | 4x4 | 6006173 | 2096415 | 37.7367055902603 | -122.421125584355 | (37.7367055902603, -122.421125584355) | 2 | 7 | 7 | 28859 | 2 | |||
87145 | 113435 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198x HIGHLAND AVE | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 4x4 | 6006173 | 2096415 | 37.7367055902603 | -122.421125584355 | (37.7367055902603, -122.421125584355) | 2 | 7 | 7 | 28859 | 2 | ||||
51837 | 113436 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198x HIGHLAND AVE | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 4x4 | 6006173 | 2096415 | 37.7367055902603 | -122.421125584355 | (37.7367055902603, -122.421125584355) | 2 | 7 | 7 | 28859 | 2 | ||||
58400 | 113437 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198x HIGHLAND AVE | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 4x4 | 6006173 | 2096415 | 37.7367055902603 | -122.421125584355 | (37.7367055902603, -122.421125584355) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | |||
71624 | 113963 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Rhode Island St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2015 12:00:00 AM | 8 | 3x3 | 6011667.06303 | 2107250.97581 | 37.7667670024209 | -122.402892005557 | (37.7667670024209, -122.402892005557) | 8 | 2 | 8 | 28853 | 20 | ||
108751 | 113964 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Rhode Island St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2015 12:00:00 AM | 11 | 3x3 | 6011665.76024 | 2107233.19616 | 37.7667181107677 | -122.402895261101 | (37.7667181107677, -122.402895261101) | 8 | 2 | 8 | 28853 | 20 | ||
62566 | 113965 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Rhode Island St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6011669.50654 | 2107216.87583 | 37.7666735080099 | -122.402881155253 | (37.7666735080099, -122.402881155253) | 8 | 2 | 8 | 28853 | 20 | |||
136111 | 113966 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Rhode Island St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6011669.86697 | 2107203.74799 | 37.7666374820482 | -122.402878985182 | (37.7666374820482, -122.402878985182) | 8 | 2 | 8 | 28853 | 20 | |||
28121 | 113967 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 200 RHODE ISLAND ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011658 | 2107333 | 37.7669917162652 | -122.402929122897 | (37.7669917162652, -122.402929122897) | 8 | 2 | 8 | 28853 | 20 | ||||
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 | ||||
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 | ||||
90155 | 11435 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6005584.47186 | 2117242.36199 | 37.7938593821703 | -122.424641513005 | (37.7938593821703, -122.424641513005) | 13 | 9 | 1 | 28858 | 27 | |||
147150 | 11437 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100X Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005576.77796 | 2117294.00706 | 37.7940007519905 | -122.424671810255 | (37.7940007519905, -122.424671810255) | 13 | 9 | 1 | 28858 | 27 | |||
159730 | 11438 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100X FRANKLIN ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005630 | 2117242 | 37.7938609593863 | -122.424483955414 | (37.7938609593863, -122.424483955414) | 13 | 9 | 1 | 28858 | 27 | |||
59499 | 114431 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2787 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000638 | 2114779 | 37.7868150321065 | -122.441579867848 | (37.7868150321065, -122.441579867848) | 13 | 6 | 1 | 29490 | 27 | ||||
92422 | 114432 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 700 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777170 | 5992893.39745 | 2110635.08838 | 37.774992699186 | -122.468072606609 | (37.774992699186, -122.468072606609) | 11 | 6 | 2 | 54 | 11 | ||
84350 | 114458 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1455 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000876.4539 | 2110325.3314 | 37.7745999769916 | -122.440435340128 | (37.7745999769916, -122.440435340128) | 15 | 5 | 11 | 29492 | 10 | |||
63587 | 114459 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1455 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6000893.3376 | 2110327.3177 | 37.7746063922099 | -122.440377078704 | (37.7746063922099, -122.440377078704) | 15 | 5 | 11 | 29492 | 10 | |||
110642 | 114466 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2351 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009278.4623 | 2121786.53745 | 37.8065444922964 | -122.412181221704 | (37.8065444922964, -122.412181221704) | 3 | 1 | 10 | 308 | 23 | |||
193318 | 114467 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2351 Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6009280.92289 | 2121766.47886 | 37.8064895545061 | -122.412171287793 | (37.8064895545061, -122.412171287793) | 3 | 1 | 10 | 308 | 23 | |||
172898 | 114468 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2351 Powell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6009284.18017 | 2121746.40432 | 37.8064346176217 | -122.412158595669 | (37.8064346176217, -122.412158595669) | 3 | 1 | 10 | 308 | 23 | |||
177774 | 114469 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2351 Powell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6009301.69448 | 2121635.8419 | 37.8061320236498 | -122.41209016534 | (37.8061320236498, -122.41209016534) | 3 | 1 | 10 | 308 | 23 | |||
54535 | 114470 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2351 Powell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6009302.49876 | 2121620.58079 | 37.8060901655936 | -122.412086302768 | (37.8060901655936, -122.412086302768) | 3 | 1 | 10 | 308 | 23 | |||
48534 | 114558 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1870 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 3 | Permit Number 777072 | 6005244.08524 | 2117174.62604 | 37.7936541667538 | -122.425814460096 | (37.7936541667538, -122.425814460096) | 13 | 9 | 1 | 28858 | 27 | ||
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 | ||||
93252 | 114797 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 103 Grattan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998130.9907032 | 2106502.59817932 | 37.7639470183873 | -122.44965687079 | (37.7639470183873, -122.44965687079) | 15 | 5 | 11 | 29492 | 9 | ||||
61993 | 114798 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 103 Grattan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998130.9907032 | 2106502.59817932 | 37.7639470183873 | -122.44965687079 | (37.7639470183873, -122.44965687079) | 15 | 5 | 11 | 29492 | 9 | ||||
39157 | 114799 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 103 Grattan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998130.9907032 | 2106502.59817932 | 37.7639470183873 | -122.44965687079 | (37.7639470183873, -122.44965687079) | 15 | 5 | 11 | 29492 | 9 | ||||
43654 | 114877 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 226 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001315 | 2109584 | 37.7725894276985 | -122.438865189694 | (37.7725894276985, -122.438865189694) | 15 | 5 | 11 | 29492 | 9 | ||||
138352 | 114878 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 226 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001315 | 2109584 | 37.7725894276985 | -122.438865189694 | (37.7725894276985, -122.438865189694) | 15 | 5 | 11 | 29492 | 9 | ||||
23747 | 115658 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1499X HAYES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000749 | 2110266 | 37.7744298099173 | -122.440871970116 | (37.7744298099173, -122.440871970116) | 15 | 5 | 11 | 29492 | 10 | |||
77770 | 115659 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1499X HAYES ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000749 | 2110266 | 37.7744298099173 | -122.440871970116 | (37.7744298099173, -122.440871970116) | 15 | 5 | 11 | 29492 | 10 | |||
76069 | 115717 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1533 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2016 12:00:00 AM | 3 | 3x3 | 6006572.5 | 2115603.9 | 37.78941632368 | -122.421106442083 | (37.78941632368, -122.421106442083) | 13 | 9 | 10 | 28858 | 21 | ||
110109 | 116049 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 650x Kansas St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 4x4 | 6011498.3385 | 2105356.0244 | 37.7615544688802 | -122.403342277248 | (37.7615544688802, -122.403342277248) | 10 | 3 | 8 | 28856 | 29 | ||
41878 | 116060 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100x 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 7 | 3x3 | 6011408.71891 | 2105130.5396 | 37.7609303321981 | -122.403636370817 | (37.7609303321981, -122.403636370817) | 10 | 3 | 8 | 28856 | 29 | ||
72925 | 116811 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3660x 23RD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005401 | 2102665 | 37.7538231135776 | -122.42423909942 | (37.7538231135776, -122.42423909942) | 2 | 4 | 5 | 28859 | 19 | ||||
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 | ||||
58177 | 117520 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1601 PAGE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998904 | 2109014 | 37.7708868872166 | -122.447164026359 | (37.7708868872166, -122.447164026359) | 15 | 5 | 11 | 29492 | 9 | ||||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
133053 | 120901 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2032 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778866 | 6001448.95372 | 2115547.55562 | 37.7889714571097 | -122.438829258958 | (37.7889714571097, -122.438829258958) | 13 | 6 | 1 | 29490 | 27 | |
194010 | 120978 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 699X Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007023 | 2113270 | 37.7830333917519 | -122.419382121036 | (37.7830333917519, -122.419382121036) | 7 | 9 | 9 | 28852 | 36 | ||||
84106 | 121040 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2101 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118098 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | 13 | 9 | 10 | 28858 | 32 | ||||
123182 | 121041 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2101 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118098 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | 13 | 9 | 10 | 28858 | 32 | ||||
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 | |||
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 | |||
69299 | 121398 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 4098x 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002425 | 2104765 | 37.7594207214866 | -122.434680934086 | (37.7594207214866, -122.434680934086) | 2 | 4 | 5 | 28862 | 3 | ||||
9687 | 121554 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 330 Eureka St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 779292 | 6001441 | 2103840 | 37.7568249841019 | -122.438017823933 | (37.7568249841019, -122.438017823933) | 2 | 4 | 5 | 28862 | 3 | ||
24777 | 121592 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 4233 Cesar Chavez St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6002342 | 2100313 | 37.7471918787018 | -122.434649642859 | (37.7471918787018, -122.434649642859) | 2 | 4 | 5 | 63 | 22 | ||||
191692 | 121621 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 298X Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998141 | 2093851 | 37.7292093905587 | -122.448710954214 | (37.7292093905587, -122.448710954214) | 9 | 7 | 4 | 28861 | 40 | ||||
128931 | 121622 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 298X Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998141 | 2093851 | 37.7292093905587 | -122.448710954214 | (37.7292093905587, -122.448710954214) | 9 | 7 | 4 | 28861 | 40 | ||||
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 | |||
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 | |||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
188349 | 12174 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1415X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6016429.111 | 2095062.9295 | 37.7335659143966 | -122.385571222674 | (37.7335659143966, -122.385571222674) | 10 | 3 | 8 | 58 | 1 | |||
183264 | 12175 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1413X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016419.0642 | 2095079.8835 | 37.7336119107928 | -122.385607138859 | (37.7336119107928, -122.385607138859) | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
184036 | 12181 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1401X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016385.1563 | 2095160.2578 | 37.7338307263114 | -122.385729969415 | (37.7338307263114, -122.385729969415) | 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 | |||
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 | |||
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 | |||
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 |
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) );