Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
143719 | 143719 | 8223 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1500X Galvez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/10/2015 08:24:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
143971 | 143971 | 114720 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 465 Woolsey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010466.6 | 2091788.0 | 37.724241933851296 | -122.405954818575 | (37.7242419338513, -122.405954818575) | |||
144702 | 144702 | 112554 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 35 DOLORES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/2015 12:00:00 AM | 3x3 | 6004913.0 | 2108042.0 | 37.7685595148495 | -122.426309519551 | (37.7685595148495, -122.426309519551) | |||
145185 | 145185 | 99291 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1300 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | 3x3 | Permit Number 768897 | 6015320.4 | 2102511.6 | 37.753957014382 | -122.38992452193199 | (37.753957014382, -122.389924521932) | ||
149661 | 149661 | 95133 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 450@ Wayland Somerset St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2010 12:00:00 AM | 1 | 3x3 | Permit Number 54066 | 6010089.84133 | 2092358.2905700002 | 37.725786753837 | -122.407297408351 | (37.725786753837, -122.407297408351) | |
150867 | 150867 | 230315 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 131 Peralta Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010141.9244099995 | 2100150.42012 | 37.7471851875523 | -122.407666527004 | (37.7471851875523, -122.407666527004) | |||
151961 | 151961 | 177422 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 0 Santa Ynez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6001061.39064 | 2091803.12496 | 37.7237529577069 | -122.438468271097 | (37.7237529577069, -122.438468271097) | |||
153237 | 153237 | 50024 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1704 Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 3 | Permit Number 46757 | 6005953.2164199995 | 2092396.45471 | 37.725659158041104 | -122.421600147046 | (37.7256591580411, -122.421600147046) | |
153469 | 153469 | 131001 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 937 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007906.15602 | 2120261.72441 | 37.80228064460721 | -122.416822257668 | (37.8022806446072, -122.416822257668) | |||
153672 | 153672 | 230305 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3689 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6005047.22841 | 2104845.66376 | 37.7597907229735 | -122.42561771539499 | (37.7597907229735, -122.425617715395) | |||
155809 | 155809 | 193320 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2111 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6011400.26798 | 2105549.24377 | 37.762079528159795 | -122.403695060604 | (37.7620795281598, -122.403695060604) | |||
159964 | 159964 | 193358 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 62 Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014021.3474 | 2116423.46881 | 37.79208376250261 | -122.395391515812 | (37.7920837625026, -122.395391515812) | |||
160153 | 160153 | 193360 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 208 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014042.14131 | 2116274.34783 | 37.7916754675957 | -122.395309117238 | (37.7916754675957, -122.395309117238) | |||
160737 | 160737 | 193316 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 136 Hawthorne St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 2ft | 6013300.831040001 | 2113672.81478 | 37.784491007704396 | -122.39769151127301 | (37.7844910077044, -122.397691511273) | |||
160936 | 160936 | 121810 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 106 19th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5989928.89895 | 2114601.72994 | 37.7857123459232 | -122.478617478776 | (37.7857123459232, -122.478617478776) | |||
161788 | 161788 | 130997 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2201 Leavenworth St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6007578.93915 | 2119952.7888599997 | 37.8014139751467 | -122.417932677574 | (37.8014139751467, -122.417932677574) | |||
161888 | 161888 | 217796 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 21 Sloat Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5991264.945169999 | 2095927.55542 | 37.7345154980788 | -122.472633170284 | (37.7345154980788, -122.472633170284) | |||
165587 | 165587 | 208854 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 403 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000738.2575199995 | 2095246.2380099997 | 37.7331885682037 | -122.439832030035 | (37.7331885682037, -122.439832030035) | |||
167906 | 167906 | 130986 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3147 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004613.79741 | 2120397.19916 | 37.802466888808496 | -122.42822508471599 | (37.8024668888085, -122.428225084716) | |||
168749 | 168749 | 130985 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2098 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999249.259269999 | 2121180.66389 | 37.8043130782603 | -122.44684538130501 | (37.8043130782603, -122.446845381305) | |||
171597 | 171597 | 105251 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 500 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2014 12:00:00 AM | 1 | Permit Number 771049 | 5984733.08187 | 2112389.43293 | 37.779334982299794 | -122.496429952441 | (37.7793349822998, -122.496429952441) | ||
172322 | 172322 | 230356 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 137 Randall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004658.9023 | 2097536.10277 | 37.73969841334279 | -122.42644028119 | (37.7396984133428, -122.42644028119) | |||
172336 | 172336 | 110563 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 135 Theresa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x9 | 6002082.973999999 | 2093709.6113599997 | 37.729045795311706 | -122.43507312442499 | (37.7290457953117, -122.435073124425) | |||
172672 | 172672 | 34927 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2625 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/2012 12:00:00 AM | 3 | Permit Number 768761 | 5999601.94789 | 2117876.9745400003 | 37.7952621734732 | -122.44538718908301 | (37.7952621734732, -122.445387189083) | ||
174129 | 174129 | 193351 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1752 Quesada Ave | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6014452.02014 | 2095263.45344 | 37.734006920685204 | -122.392420670182 | (37.7340069206852, -122.392420670182) | |||
181425 | 181425 | 193353 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 75 Latona St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6014356.71381 | 2094130.9148900001 | 37.730891907436295 | -122.392670976684 | (37.7308919074363, -122.392670976684) | |||
182061 | 182061 | 115977 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2x Olmstead St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011639.0005 | 2091249.90123 | 37.722829925953896 | -122.40186416949 | (37.7228299259539, -122.40186416949) | |||
182454 | 182454 | 193375 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 778 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6008954.62424 | 2110209.1337900003 | 37.774737583109705 | -122.41248303597901 | (37.7747375831097, -122.412483035979) | |||
184182 | 184182 | 230293 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3500 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6006188.70146 | 2104951.15176 | 37.7601448013679 | -122.42167740779301 | (37.7601448013679, -122.421677407793) | |||
184199 | 184199 | 193331 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1258 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015302.57075 | 2102682.83592 | 37.754426203129 | -122.38999814121 | (37.754426203129, -122.38999814121) | |||
188010 | 188010 | 230345 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1801 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004583.18993 | 2098311.13062 | 37.7418221830485 | -122.42675724096901 | (37.7418221830485, -122.426757240969) | |||
188017 | 188017 | 94885 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2010 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53951 | 6013050.0613 | 2096298.0841299999 | 37.736769849332 | -122.39734023878599 | (37.736769849332, -122.397340238786) |
188778 | 188778 | 230303 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2784 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010083.7548 | 2102826.7491599997 | 37.7545305388726 | -122.40805638669501 | (37.7545305388726, -122.408056386695) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");