trees
508 rows where qSpecies_id = 25 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1940 | 43017 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42880 | ||||||||||||||
2319 | 34069 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
3439 | 43015 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42880 | ||||||||||||||
5259 | 45154 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1683 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2001 12:00:00 AM | Permit Number 44007 | |||||||||||||
5523 | 38232 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 0 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | Permit Number 40352 | |||||||||||||
6572 | 34068 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
6767 | 38234 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 0 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | Permit Number 40352 | |||||||||||||
7060 | 38233 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 0 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | Permit Number 40352 | |||||||||||||
7097 | 34072 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
7436 | 43016 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42880 | ||||||||||||||
9043 | 43018 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42880 | ||||||||||||||
9398 | 264655 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1099 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2020 04:53:00 PM | 3x3 | |||||||||||||
12809 | 38231 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 0 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | Permit Number 40352 | |||||||||||||
14576 | 34071 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
16742 | 34070 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
17098 | 34067 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
48618 | 142233 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 600 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004546.0223 | 2110772.1475 | 37.7760350855974 | -122.427773417679 | (37.7760350855974, -122.427773417679) | 7 | 9 | 11 | 28852 | 10 | |||
53663 | 142232 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 600 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004552.0651 | 2110734.2793 | 37.7759314506272 | -122.427749815271 | (37.7759314506272, -122.427749815271) | 7 | 9 | 11 | 28852 | 10 | |||
64629 | 142235 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 689 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004665.6696 | 2110849.8982 | 37.7762553374912 | -122.42736506585 | (37.7762553374912, -122.42736506585) | 7 | 9 | 11 | 28852 | 10 | |||
67621 | 128862 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 689 Hayes St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6004674.24665 | 2110845.64244 | 37.7762441372985 | -122.427335092236 | (37.7762441372985, -122.427335092236) | 7 | 9 | 11 | 28852 | 10 | |||
92573 | 128863 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 628 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004545.79116 | 2110745.60377 | 37.7759621899439 | -122.427772325535 | (37.7759621899439, -122.427772325535) | 7 | 9 | 11 | 28852 | 10 | |||
95938 | 128864 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 628 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6004541.11924 | 2110775.90598 | 37.7760451281037 | -122.427790646526 | (37.7760451281037, -122.427790646526) | 7 | 9 | 11 | 28852 | 10 | |||
11311 | 73919 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 179 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6007979.77962 | 2109750.06791 | 37.77342234081 | -122.415822718756 | (37.77342234081, -122.415822718756) | 8 | 2 | 9 | 28853 | 34 | |||
13467 | 70988 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 179 11th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6007961.92289 | 2109767.88075 | 37.7734702467743 | -122.415885749526 | (37.7734702467743, -122.415885749526) | 8 | 2 | 9 | 28853 | 34 | |||
19983 | 36067 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1398 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39186 | 6009394 | 2107812 | 37.7681802592774 | -122.410793808029 | (37.7681802592774, -122.410793808029) | 8 | 4 | 7 | 28853 | 19 | |||
23576 | 10026 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 290 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 2x3 | 6005455.03663 | 2107324.13866 | 37.7666190630424 | -122.424383592842 | (37.7666190630424, -122.424383592842) | 8 | 4 | 5 | 28853 | 19 | |||
27755 | 82843 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 719 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52435 | 6009401.3474 | 2110338.98679 | 37.7751191888227 | -122.410946896775 | (37.7751191888227, -122.410946896775) | 8 | 2 | 9 | 28853 | 34 | |
28119 | 36065 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1398 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39186 | 6009394 | 2107812 | 37.7681802592774 | -122.410793808029 | (37.7681802592774, -122.410793808029) | 8 | 4 | 7 | 28853 | 19 | |||
44632 | 36064 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1398 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39186 | 6009394 | 2107812 | 37.7681802592774 | -122.410793808029 | (37.7681802592774, -122.410793808029) | 8 | 4 | 7 | 28853 | 19 | |||
46773 | 10037 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 351 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x2 | 6005536.77146 | 2106975.88456 | 37.765667455319 | -122.424076117338 | (37.765667455319, -122.424076117338) | 8 | 4 | 5 | 28853 | 19 | |||
51015 | 225924 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 145 Guerrero St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 18 | Width 2ft | 6005469.65475 | 2108205.80814 | 37.7690407421536 | -122.424395748072 | (37.7690407421536, -122.424395748072) | 8 | 4 | 5 | 28853 | 19 | |||
63677 | 10032 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 315 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X2 | 6005527.20527 | 2107119.43239 | 37.7660610633959 | -122.424119414293 | (37.7660610633959, -122.424119414293) | 8 | 4 | 5 | 28853 | 19 | |||
77790 | 103262 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 53 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770698 | 6006511 | 2108178 | 37.769023136516 | -122.420791817714 | (37.769023136516, -122.420791817714) | 8 | 4 | 7 | 28853 | 19 | |
83440 | 32625 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 75 Boardman Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 15 | Permit Number 37080 | 6011878.08124 | 2109949.48586 | 37.7741882789872 | -122.402351882652 | (37.7741882789872, -122.402351882652) | 14 | 2 | 9 | 28853 | 34 | |
89899 | 98256 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 2800X 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007899.1 | 2106885.5 | 37.7655523739417 | -122.415898914261 | (37.7655523739417, -122.415898914261) | 8 | 4 | 7 | 28853 | 19 | |||
91462 | 245459 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2800 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6007813.0325 | 2106805.2324 | 37.765327138725 | -122.416190917981 | (37.765327138725, -122.416190917981) | 8 | 4 | 7 | 28853 | 19 | |||
93375 | 245456 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2800 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6007901.4813 | 2106811.8898 | 37.7653503913435 | -122.415885464882 | (37.7653503913435, -122.415885464882) | 8 | 4 | 7 | 28853 | 19 | |||
93399 | 32626 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 75 Boardman Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 14 | Permit Number 37080 | 6011867.62207 | 2109962.18755 | 37.7742225710588 | -122.402388956281 | (37.7742225710588, -122.402388956281) | 14 | 2 | 9 | 28853 | 34 | |
96662 | 225899 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1398 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6009375.43724 | 2107898.55121 | 37.7684168680618 | -122.41086412858 | (37.7684168680618, -122.41086412858) | 8 | 4 | 7 | 28853 | 19 | |||
107304 | 10020 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 250 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | 2x2 | 6005442.42406 | 2107520.98643 | 37.767158847823 | -122.424441220501 | (37.767158847823, -122.424441220501) | 8 | 4 | 5 | 28853 | 19 | |||
124173 | 225898 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1398 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009373.69267 | 2107922.66686 | 37.7684829862389 | -122.410871866347 | (37.7684829862389, -122.410871866347) | 8 | 4 | 7 | 28853 | 19 | |||
126795 | 245457 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2800 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6007865.341 | 2106811.8898 | 37.7653483594859 | -122.416010466111 | (37.7653483594859, -122.416010466111) | 8 | 4 | 7 | 28853 | 19 | |||
129017 | 225900 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1398 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6009378.42208 | 2107868.1744 | 37.7683336277295 | -122.410851658572 | (37.7683336277295, -122.410851658572) | 8 | 4 | 7 | 28853 | 19 | |||
131963 | 245455 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2800 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6007994.6854 | 2106818.5473 | 37.7653739107422 | -122.41556356407 | (37.7653739107422, -122.41556356407) | 8 | 4 | 7 | 28853 | 19 | |||
136146 | 98260 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 2800X 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007899.1 | 2106885.5 | 37.7655523739417 | -122.415898914261 | (37.7655523739417, -122.415898914261) | 8 | 4 | 7 | 28853 | 19 | |||
137342 | 32627 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 75 Boardman Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 15 | Permit Number 37080 | 6011835.14299 | 2109991.00563 | 37.774299885758 | -122.402503334756 | (37.774299885758, -122.402503334756) | 14 | 2 | 9 | 28853 | 34 | |
137615 | 31889 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 167 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | 15 | Permit Number 35321 | 6007897.98767 | 2109828.50999 | 37.7736331256972 | -122.416111205987 | (37.7736331256972, -122.416111205987) | 8 | 2 | 9 | 28853 | 34 | ||
137668 | 98257 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 2800X 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007899.1 | 2106885.5 | 37.7655523739417 | -122.415898914261 | (37.7655523739417, -122.415898914261) | 8 | 4 | 7 | 28853 | 19 | |||
138074 | 98258 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 2800X 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007899.1 | 2106885.5 | 37.7655523739417 | -122.415898914261 | (37.7655523739417, -122.415898914261) | 8 | 4 | 7 | 28853 | 19 | |||
139521 | 10000 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 136 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 2X2 | 6005403.54778 | 2108183.22689 | 37.7689750062251 | -122.424622801709 | (37.7689750062251, -122.424622801709) | 8 | 4 | 5 | 28853 | 19 | |||
147726 | 114483 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 784 CLEMENTINA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x2 | 6009096 | 2110140 | 37.7745556909018 | -122.411989099957 | (37.7745556909018, -122.411989099957) | 8 | 2 | 9 | 28853 | 34 | |||
151974 | 36066 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1398 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39186 | 6009394 | 2107812 | 37.7681802592774 | -122.410793808029 | (37.7681802592774, -122.410793808029) | 8 | 4 | 7 | 28853 | 19 | |||
156454 | 32624 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 39 Boardman Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 7 | Permit Number 37079 | 6011697.70075 | 2110139.81067 | 37.7747007963356 | -122.402989243876 | (37.7747007963356, -122.402989243876) | 14 | 2 | 9 | 28853 | 34 | |
166681 | 98259 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 2800X 16TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008057 | 2106814 | 37.7653649274264 | -122.415347709739 | (37.7653649274264, -122.415347709739) | 8 | 4 | 7 | 28853 | 19 | |||
172040 | 51066 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 10 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | 8 | 2 | 9 | 28853 | 19 | |||
179490 | 87141 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 169 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 12 | 3x3 | Permit Number 767576 | 6007945.36003 | 2109780.43285 | 37.7735037807007 | -122.415943932067 | (37.7735037807007, -122.415943932067) | 8 | 2 | 9 | 28853 | 34 |
181241 | 10001 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 145 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X2 | 6005474.27283 | 2108090.23028 | 37.7687236538132 | -122.424371552702 | (37.7687236538132, -122.424371552702) | 8 | 4 | 5 | 28853 | 19 | |||
192132 | 112711 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 782 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 1 | 6009126.82605 | 2110111.36785 | 37.774478803191 | -122.411880442527 | (37.774478803191, -122.411880442527) | 8 | 2 | 9 | 28853 | 34 | ||
11961 | 115127 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
69946 | 115126 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
109240 | 115128 | Private 9 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
128761 | 115129 | Private 9 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
181947 | 115130 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
636 | 67551 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 655 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 8 | Permit Number 31099 | 6011561.87177 | 2105285.59303 | 37.7613646282886 | -122.403117586111 | (37.7613646282886, -122.403117586111) | 10 | 3 | 8 | 28856 | 29 | |
993 | 67493 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 740 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/1992 12:00:00 AM | 8 | Permit Number 31018 | 6011800.9294 | 2105019.52264 | 37.7606474054712 | -122.402272073209 | (37.7606474054712, -122.402272073209) | 10 | 3 | 8 | 28856 | 29 | ||
1757 | 261740 | Section 806 (d) 5 | Geijera parviflora :: Australian Willow 25 | 540 De Haro St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
3374 | 261742 | Section 806 (d) 5 | Geijera parviflora :: Australian Willow 25 | 540 De Haro St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
3438 | 194171 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 740 Rhode Island St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 7ft | 6011792.75247 | 2105015.27083 | 37.7606352745052 | -122.402300054726 | (37.7606352745052, -122.402300054726) | 10 | 3 | 8 | 28856 | 29 | |||
5885 | 261744 | Section 806 (d) 5 | Geijera parviflora :: Australian Willow 25 | 540 De Haro St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
12766 | 261739 | Section 806 (d) 5 | Geijera parviflora :: Australian Willow 25 | 540 De Haro St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
14638 | 261745 | Section 806 (d) 5 | Geijera parviflora :: Australian Willow 25 | 540 De Haro St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
14658 | 261743 | Section 806 (d) 5 | Geijera parviflora :: Australian Willow 25 | 540 De Haro St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
16190 | 34502 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1415 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1997 12:00:00 AM | 9 | Permit Number 38224 | 6013698.3172 | 2104744.62684 | 37.7599983314835 | -122.395690557494 | (37.7599983314835, -122.395690557494) | 10 | 3 | 8 | 28856 | 29 | |
16452 | 261741 | Section 806 (d) 5 | Geijera parviflora :: Australian Willow 25 | 540 De Haro St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
16692 | 78621 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2140 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011632.94564 | 2104677.50372 | 37.7596989192821 | -122.402829001752 | (37.7596989192821, -122.402829001752) | 10 | 3 | 8 | 28856 | 29 | |||
17201 | 72137 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1445 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6013608.91395 | 2104739.63414 | 37.7599796489713 | -122.395999412568 | (37.7599796489713, -122.395999412568) | 10 | 3 | 8 | 28856 | 29 | |||
17383 | 258113 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 144 Freelon St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 6013235.08289 | 2111410.77261 | 37.7782762981131 | -122.397760259133 | (37.7782762981131, -122.397760259133) | 6 | 2 | 9 | 28856 | 34 | |||||
17567 | 150775 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2004 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 4x5 | 6012077.37529 | 2103767.84682 | 37.757226007585 | -122.401228007969 | (37.757226007585, -122.401228007969) | 10 | 3 | 8 | 28856 | 29 | |
18508 | 79749 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 615 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6015454.74686 | 2106112.32495 | 37.7638512843329 | -122.389711390588 | (37.7638512843329, -122.389711390588) | 14 | 3 | 8 | 28856 | 29 | |||
22071 | 192422 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 80 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6012207.07921 | 2107722.19142 | 37.7680909933277 | -122.401057281578 | (37.7680909933277, -122.401057281578) | 14 | 3 | 8 | 28856 | 20 | |||
30403 | 32983 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 618 Texas St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37296 | 6013812.07366772 | 2104214.5102771 | 37.7585490739971 | -122.395259990599 | (37.7585490739971, -122.395259990599) | 10 | 3 | 8 | 28856 | 29 | ||
33588 | 192415 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1400 20th St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6013731.20085 | 2104795.92406 | 37.7601410116297 | -122.39558042201 | (37.7601410116297, -122.39558042201) | 10 | 3 | 8 | 28856 | 29 | |||
39253 | 66067 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1425 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1990 12:00:00 AM | 12 | Permit Number 29107 | 6013650.29046 | 2104740.70593 | 37.7599848938155 | -122.395856385278 | (37.7599848938155, -122.395856385278) | 10 | 3 | 8 | 28856 | 29 | |
41661 | 49835 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 587 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 11 | Permit Number 46618 | 6014427.95757 | 2104386.86383 | 37.7590565524297 | -122.393142029905 | (37.7590565524297, -122.393142029905) | 10 | 3 | 8 | 28856 | 29 | |
42236 | 66180 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1409 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1990 12:00:00 AM | 12 | Permit Number 29257 | 6013724.4666 | 2104745.52937 | 37.7600022642143 | -122.395600181905 | (37.7600022642143, -122.395600181905) | 10 | 3 | 8 | 28856 | 29 | |
42562 | 192418 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Sierra St | 2 | : | Tree | Private 2 | 9 | Width 5ft | 6013740.02795 | 2104156.22974 | 37.7583850412574 | -122.395505075892 | (37.7583850412574, -122.395505075892) | 10 | 3 | 8 | 28856 | 29 | |||
44550 | 192417 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Sierra St | 1 | : | Tree | Private 2 | 11 | Width 5ft | 6013758.38911 | 2104156.54332 | 37.7583869235411 | -122.395441596376 | (37.7583869235411, -122.395441596376) | 10 | 3 | 8 | 28856 | 29 | |||
45964 | 67574 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 601 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 13 | Permit Number 31129 | 6013300.57075 | 2104280.61777 | 37.7587021305084 | -122.397033645504 | (37.7587021305084, -122.397033645504) | 10 | 3 | 8 | 28856 | 29 | |
49729 | 192424 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 80 Carolina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6012214.21558 | 2107593.00345 | 37.767736670334 | -122.401023519214 | (37.767736670334, -122.401023519214) | 14 | 3 | 8 | 28856 | 20 | |||
50638 | 192419 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Sierra St | 3 | : | Tree | Private 2 | 8 | Width 5ft | 6013725.78081 | 2104155.14731 | 37.7583812766799 | -122.395554273333 | (37.7583812766799, -122.395554273333) | 10 | 3 | 8 | 28856 | 29 | |||
51882 | 32986 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 10X Sierra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 5x9 | Permit Number 37296 | 6013812.07366772 | 2104214.5102771 | 37.7585490739971 | -122.395259990599 | (37.7585490739971, -122.395259990599) | 10 | 3 | 8 | 28856 | 29 | |
57421 | 32985 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 10X Sierra St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 5x9 | Permit Number 37296 | 6013812.07366772 | 2104214.5102771 | 37.7585490739971 | -122.395259990599 | (37.7585490739971, -122.395259990599) | 10 | 3 | 8 | 28856 | 29 | |
58513 | 102247 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 337 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 5x9 | 6014078.6922 | 2105447.06495 | 37.7619482253485 | -122.394424198727 | (37.7619482253485, -122.394424198727) | 10 | 3 | 8 | 28856 | 29 | |||
73497 | 192408 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 799 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011594.92882 | 2104699.39002 | 37.7597568913958 | -122.4029620232 | (37.7597568913958, -122.4029620232) | 10 | 3 | 8 | 28856 | 29 | |||
74085 | 78433 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 870 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2016 12:00:00 AM | 3 | 6011558.92592 | 2104265.3143 | 37.7585630053957 | -122.403056007737 | (37.7585630053957, -122.403056007737) | 10 | 3 | 8 | 28856 | 29 | ||
77221 | 32926 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1530 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 9 | Permit Number 37252 | 6012714.10584 | 2106606.08517 | 37.765054686045 | -122.399225162022 | (37.765054686045, -122.399225162022) | 14 | 3 | 8 | 28856 | 20 | |
79612 | 105962 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 10X Sierra St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x9 | 6013706.37383 | 2104134.52437 | 37.7583235710722 | -122.395619946844 | (37.7583235710722, -122.395619946844) | 10 | 3 | 8 | 28856 | 29 | ||||
81760 | 192405 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1900 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012343.89644 | 2104716.44706 | 37.7598455204762 | -122.400372895689 | (37.7598455204762, -122.400372895689) | 10 | 3 | 8 | 28856 | 29 | |||
82691 | 192420 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Sierra St | 4 | : | Tree | Private 2 | 8 | Width 5ft | 6013708.56182 | 2104154.58233 | 37.7583787675789 | -122.395613785069 | (37.7583787675789, -122.395613785069) | 10 | 3 | 8 | 28856 | 29 | |||
83654 | 49830 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 225 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 5 | 3x3 | Permit Number 46613 | 6013486.20588 | 2106002.24827 | 37.7634396826096 | -122.396512309398 | (37.7634396826096, -122.396512309398) | 14 | 3 | 8 | 28856 | 29 |
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) );