Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantDate, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22588 | 22588 | 7129 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 4 | 3X3 | 6005508.68317 | 2114972.6560299997 | 37.787623057713496 | -122.424742207381 | (37.7876230577135, -122.424742207381) | ||
24395 | 24395 | 92752 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3356 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52980 | 5999300.27951 | 2120375.08626 | 37.8021040941904 | -122.446610827352 | (37.8021040941904, -122.446610827352) | |
27386 | 27386 | 220596 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 452 Shotwell St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6007814.59662 | 2105186.38117 | 37.7608822364448 | -122.416070852512 | (37.7608822364448, -122.416070852512) | |||
28260 | 28260 | 92446 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1554 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52837 | 5981923.4 | 2104509.6 | 37.7575342433798 | -122.505565385243 | (37.7575342433798, -122.505565385243) |
30833 | 30833 | 220633 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 18 Kronquist Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 6002213.10405 | 2100169.21088 | 37.7467897493647 | -122.435085071929 | (37.7467897493647, -122.435085071929) | |||
31567 | 31567 | 203453 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2658 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991457.8354 | 2097316.5348 | 37.738340446961104 | -122.47206749851001 | (37.7383404469611, -122.47206749851) | |||
31793 | 31793 | 221773 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5587 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6001626.70915 | 2097120.97663 | 37.7383866990834 | -122.436894581628 | (37.7383866990834, -122.436894581628) | |||
33494 | 33494 | 175166 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 218 Congdon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004672.7463 | 2094000.25869 | 37.7299905627997 | -122.426140758388 | (37.7299905627997, -122.426140758388) | |||
33859 | 33859 | 220622 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 58 Fountain St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6000334.98133 | 2101342.05017 | 37.7499032598351 | -122.441663574927 | (37.7499032598351, -122.441663574927) | |||
36512 | 36512 | 175167 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 218 Congdon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004673.57343 | 2093985.3797 | 37.7299497551534 | -122.426136840057 | (37.7299497551534, -122.426136840057) | |||
36697 | 36697 | 220597 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 452 Shotwell St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6007815.2262 | 2105168.52935 | 37.7608332548635 | -122.416067410784 | (37.7608332548635, -122.416067410784) | |||
37156 | 37156 | 189173 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1960 Quesada Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6013345.84088 | 2096070.7044 | 37.73616197508429 | -122.396301660307 | (37.7361619750843, -122.396301660307) | |||
40963 | 40963 | 125473 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 655 Powell St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6010077.67437 | 2116003.04391 | 37.7907092485717 | -122.409007053757 | (37.7907092485717, -122.409007053757) | |||
41684 | 41684 | 203490 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 29 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001874.24208 | 2094906.2061700001 | 37.7323195164307 | -122.43588030914302 | (37.7323195164307, -122.435880309143) | |||
43603 | 43603 | 249538 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 7 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6006360.10871 | 2114050.0114700003 | 37.785137754239294 | -122.421730877876 | (37.7851377542393, -122.421730877876) | |||
43939 | 43939 | 203498 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 234 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999190.87551 | 2094097.9228400001 | 37.72994736206179 | -122.445099202768 | (37.7299473620618, -122.445099202768) | |||
45739 | 45739 | 249986 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011589.33259 | 2120106.08083 | 37.802059763014 | -122.404065643309 | (37.802059763014, -122.404065643309) | |||
48362 | 48362 | 125504 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1001 Lombard St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 6007489.69173 | 2120199.0729400003 | 37.8020851859507 | -122.418258985774 | (37.8020851859507, -122.418258985774) | |||
48661 | 48661 | 125469 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1177 California St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6008779.73096 | 2116281.55689 | 37.791401184258795 | -122.413517591782 | (37.7914011842588, -122.413517591782) | |||
50982 | 50982 | 220615 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3117 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009011.326230001 | 2104478.69915 | 37.75900631630999 | -122.411881867955 | (37.75900631631, -122.411881867955) | |||
52304 | 52304 | 220625 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 665 Elizabeth St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6002079.843669999 | 2102040.673 | 37.751920772823794 | -122.43567974235 | (37.7519207728238, -122.43567974235) | |||
52909 | 52909 | 175174 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Vienna St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6003793.29108 | 2091173.5648599998 | 37.722179343787396 | -122.428979687879 | (37.7221793437874, -122.428979687879) | |||
55787 | 55787 | 189171 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 672 Missouri St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 1ft | 6013547.271380001 | 2103937.2716200002 | 37.7577731065529 | -122.396156373043 | (37.7577731065529, -122.396156373043) | |||
57215 | 57215 | 175165 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 218 Congdon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004671.92277 | 2094015.32561 | 37.730031886663 | -122.42614467765 | (37.730031886663, -122.42614467765) | |||
64600 | 64600 | 203500 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 77 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5999471.94159 | 2093749.5809 | 37.729006934723 | -122.444102506626 | (37.729006934723, -122.444102506626) | |||
70954 | 70954 | 125443 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2298 Beach St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5999265.80635 | 2120844.85189 | 37.8033919746241 | -122.446763941418 | (37.8033919746241, -122.446763941418) | |||
71361 | 71361 | 203465 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 480 Hearst Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 5998202.03163 | 2094421.3515299999 | 37.7307789309899 | -122.448541023359 | (37.7307789309899, -122.448541023359) | |||
75445 | 75445 | 220658 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 172 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007553.6507 | 2100235.86656 | 37.7472745765577 | -122.416622650424 | (37.7472745765577, -122.416622650424) | |||
75833 | 75833 | 41617 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2285 Jerrold Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/16/2002 12:00:00 AM | 4 | Permit Number 44542 | 6011837.54866 | 2099572.35682 | 37.7456927230357 | -122.40176253082501 | (37.7456927230357, -122.401762530825) | |
76457 | 76457 | 125449 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3101 Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5999876.27718 | 2115725.0378099997 | 37.789369177790206 | -122.444283251471 | (37.7893691777902, -122.444283251471) | |||
131923 | 131923 | 125440 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3517 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6000220.82214 | 2120372.11662 | 37.8021484793247 | -122.44342510578801 | (37.8021484793247, -122.443425105788) | |||
132173 | 132173 | 203487 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 828 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5998282.181969999 | 2096469.8668799999 | 37.736408249925 | -122.44841139867201 | (37.736408249925, -122.448411398672) | |||
137147 | 137147 | 220593 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008525.9203 | 2107974.98193 | 37.768579058113104 | -122.413807947778 | (37.7685790581131, -122.413807947778) | |||
137268 | 137268 | 203489 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 296 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996836.5401099995 | 2096166.78672 | 37.7354933057555 | -122.45338768751101 | (37.7354933057555, -122.453387687511) | |||
148997 | 148997 | 125441 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3517 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6000221.62171 | 2120363.5906700003 | 37.8021251149445 | -122.443421726125 | (37.8021251149445, -122.443421726125) | |||
149835 | 149835 | 125493 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6006021.473809999 | 2120333.6545700002 | 37.8023719590496 | -122.42334930055401 | (37.8023719590496, -122.423349300554) | |||
151252 | 151252 | 125507 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 7 Fallon Pl | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6008925.22265 | 2118571.08085 | 37.7976958234636 | -122.41317615966801 | (37.7976958234636, -122.413176159668) | |||
151503 | 151503 | 248095 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 8 Brewster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6010444.10359 | 2099844.52048 | 37.746362164885 | -122.406600056945 | (37.746362164885, -122.406600056945) | |||
153001 | 153001 | 92753 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3356 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52980 | 5999299.39389 | 2120397.7877700003 | 37.802166375831106 | -122.446615526285 | (37.8021663758311, -122.446615526285) | |
153546 | 153546 | 221756 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3649 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004058.63602 | 2103618.7990900003 | 37.7563661334022 | -122.42894929977699 | (37.7563661334022, -122.428949299777) | |||
154495 | 154495 | 175170 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 364 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004288.38035 | 2091053.9849099999 | 37.7218790151804 | -122.427259769545 | (37.7218790151804, -122.427259769545) | |||
156031 | 156031 | 220594 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008571.39642 | 2107977.23283 | 37.768587792328894 | -122.413650808341 | (37.7685877923289, -122.413650808341) | |||
156515 | 156515 | 220626 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 665 Elizabeth St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6002107.5344 | 2102041.80892 | 37.7519254645963 | -122.43558406527599 | (37.7519254645963, -122.435584065276) | |||
159436 | 159436 | 51699 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 270 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2005 12:00:00 AM | 4 | Permit Number 47975 | 6009229.913509999 | 2094736.03223 | 37.7322673611424 | -122.410437947053 | (37.7322673611424, -122.410437947053) | ||
163571 | 163571 | 203488 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 296 Cresta Vista Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996843.32855 | 2096168.5125900002 | 37.735498433689706 | -122.45336434200199 | (37.7354984336897, -122.453364342002) | |||
169661 | 169661 | 220617 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 960 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999730.468230001 | 2101939.14181 | 37.7515082672912 | -122.44379689543699 | (37.7515082672912, -122.443796895437) | |||
172117 | 172117 | 125492 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6006010.16913 | 2120331.72981 | 37.8023660361287 | -122.42338828343901 | (37.8023660361287, -122.423388283439) | |||
172952 | 172952 | 248094 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 8 Brewster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6010447.33936 | 2099861.6956599997 | 37.7464095052133 | -122.406590078085 | (37.7464095052133, -122.406590078085) | |||
173180 | 173180 | 66747 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 731 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/1996 12:00:00 AM | 4 | Permit Number 32132 | 5983183.98032 | 2110807.82823 | 37.7749014841497 | -122.501671811672 | (37.7749014841497, -122.501671811672) | |
173963 | 173963 | 203499 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 379 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5997569.0689199995 | 2093791.20398 | 37.7290124835419 | -122.45068384968799 | (37.7290124835419, -122.450683849688) | |||
178320 | 178320 | 248096 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 8 Brewster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6010442.96014 | 2099835.6038900004 | 37.7463376179016 | -122.406603382642 | (37.7463376179016, -122.406603382642) | |||
179368 | 179368 | 37653 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1707 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 4 | Permit Number 40063 | 5990244.837669999 | 2111259.2640400003 | 37.7765532018856 | -122.477280073273 | (37.7765532018856, -122.477280073273) | |
183705 | 183705 | 249985 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011591.62105 | 2120106.88257 | 37.802062092258 | -122.40405778055799 | (37.802062092258, -122.404057780558) |
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");