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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21452 | 21452 | 569 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2970 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6009068.4734 | 2102184.68731 | 37.7527106833549 | -122.411522150837 | (37.7527106833549, -122.411522150837) | |||
20951 | 20951 | 592 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3056 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6008558.8392900005 | 2102157.7680200003 | 37.752608169649 | -122.41328265918699 | (37.752608169649, -122.413282659187) | |||
18661 | 18661 | 598 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3070 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3x3 | 6008489.074019999 | 2102147.94889 | 37.75257729142999 | -122.41352322603399 | (37.75257729143, -122.413523226034) | |||
19961 | 19961 | 600 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3078 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6008460.582 | 2102146.28241 | 37.7525711157729 | -122.41362163882401 | (37.7525711157729, -122.413621638824) | |||
21513 | 21513 | 604 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3090 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6008414.92242 | 2102144.51738 | 37.752563705358604 | -122.413779413197 | (37.7525637053586, -122.413779413197) | |||
20158 | 20158 | 605 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3098 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6008383.72095 | 2102142.9064 | 37.752557529712895 | -122.41388719964701 | (37.7525575297129, -122.413887199647) | |||
20356 | 20356 | 620 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3145 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6008061.58213 | 2102085.15012 | 37.752380847108604 | -122.41499712672 | (37.7523808471086, -122.41499712672) | |||
18462 | 18462 | 623 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3158 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6007941.8237 | 2102115.0630200002 | 37.7524562507759 | -122.415413389641 | (37.7524562507759, -122.415413389641) | |||
17117 | 17117 | 625 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3160 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4x6 | 6007920.1411 | 2102115.05717 | 37.7524550160009 | -122.415488371495 | (37.7524550160009, -122.415488371495) | |||
18232 | 18232 | 630 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3176 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 6007837.40103 | 2102111.35303 | 37.752440194268395 | -122.41577423901501 | (37.7524401942684, -122.415774239015) | |||
17807 | 17807 | 640 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3214 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6007574.72227 | 2102100.08892 | 37.7523944952223 | -122.41668183031601 | (37.7523944952223, -122.416681830316) | |||
20895 | 20895 | 641 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3208 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6007604.52296 | 2102099.47851 | 37.7523944952114 | -122.41657873113 | (37.7523944952114, -122.41657873113) | |||
20129 | 20129 | 642 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3225 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6007512.22413 | 2102054.36572 | 37.7522654344184 | -122.416894720512 | (37.7522654344184, -122.416894720512) | |||
17817 | 17817 | 643 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3224 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6007548.56119 | 2102101.97423 | 37.752398200442 | -122.41677243341199 | (37.752398200442, -122.416772433412) | |||
20968 | 20968 | 655 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3255X 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 06/02/1992 12:00:00 AM | 12 | 3x4 | 6007319.73993 | 2102042.10408 | 37.7522209377659 | -122.41755949396901 | (37.7522209377659, -122.417559493969) | ||
19861 | 19861 | 656 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3255X 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 12 | 4x4 | 6007336.00672 | 2102041.77073 | 37.7522209377618 | -122.41750321711099 | (37.7522209377618, -122.417503217111) | |||
22195 | 22195 | 1351 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 271 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999796.36324 | 2099302.3291700003 | 37.7442719740833 | -122.443379644158 | (37.7442719740833, -122.443379644158) | |||
19453 | 19453 | 1923 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 78 Berkeley Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6001189.660619999 | 2097346.8097900003 | 37.7389819342562 | -122.43842185440901 | (37.7389819342562, -122.438421854409) | |||
19320 | 19320 | 5332 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 125 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 6x7 | 6004849.91389 | 2107615.9681599997 | 37.7673861676625 | -122.42649738994601 | (37.7673861676625, -122.426497389946) | |||
20645 | 20645 | 5358 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 230 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6004797.6722800005 | 2107012.30465 | 37.765725699015604 | -122.426635095043 | (37.7657256990156, -122.426635095043) | |||
20031 | 20031 | 5670 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1416 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6005182.49595 | 2100071.1312 | 37.7466886088884 | -122.424810216828 | (37.7466886088884, -122.424810216828) | |||
11475 | 11475 | 13369 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 900 Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X50 | 6009189.31279 | 2090017.3428599997 | 37.71930856033371 | -122.410245275395 | (37.7193085603337, -122.410245275395) | |||
1622 | 1622 | 15770 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 4770 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 3 | 3X3 | 6001421.7162 | 2091049.3752 | 37.721703820816394 | -122.43716874658399 | (37.7217038208164, -122.437168746584) | ||
20778 | 20778 | 22835 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 104 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1994 12:00:00 AM | 20 | 2X2 | 5999575.13645 | 2098938.39255 | 37.743260073094504 | -122.44411845071899 | (37.7432600730945, -122.444118450719) | ||
18629 | 18629 | 23094 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1384 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/1992 12:00:00 AM | 3 | 3x3 | 6006412.34173 | 2101544.72785 | 37.750804156590206 | -122.42066211905701 | (37.7508041565902, -122.420662119057) | ||
20707 | 20707 | 24450 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1384 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6006415.18821 | 2101529.37673 | 37.7507621663522 | -122.42065118602301 | (37.7507621663522, -122.420651186023) | |||
17610 | 17610 | 24602 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 419 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007254.49022 | 2097303.30919 | 37.7392055992492 | -122.41744932972401 | (37.7392055992492, -122.417449329724) | |||
11311 | 11311 | 25396 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 945 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6000465.251630001 | 2089064.76788 | 37.7162001220051 | -122.440332727576 | (37.7162001220051, -122.440332727576) | |||
13913 | 13913 | 26001 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1711 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6014400.39468 | 2095925.2599900002 | 37.735821239067796 | -122.392645436853 | (37.7358212390678, -122.392645436853) | |||
14200 | 14200 | 26002 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1711 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6014429.78226 | 2095903.68978 | 37.7357636437757 | -122.392542323281 | (37.7357636437757, -122.392542323281) | |||
16498 | 16498 | 26003 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1711 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6014451.27252 | 2095887.995 | 37.7357217425631 | -122.39246692501999 | (37.7357217425631, -122.39246692502) | |||
18006 | 18006 | 26514 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2880 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008952.92902 | 2101706.37447 | 37.7513908617048 | -122.411887928494 | (37.7513908617048, -122.411887928494) | |||
20672 | 20672 | 26517 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2883 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6009010.68122 | 2101716.60139 | 37.7514221824079 | -122.411688936397 | (37.7514221824079, -122.411688936397) | |||
91480 | 91480 | 30505 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1500 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 34518 | 6007587.04685478 | 2110100.36731732 | 37.7743620934089 | -122.417206068405 | (37.7743620934089, -122.417206068405) | |||
81461 | 81461 | 30532 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1020 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.776812772940005 | -122.404779881684 | (37.77681277294, -122.404779881684) | |||
85365 | 85365 | 30533 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1020 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.776812772940005 | -122.404779881684 | (37.77681277294, -122.404779881684) | |||
81288 | 81288 | 30534 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1020 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.776812772940005 | -122.404779881684 | (37.77681277294, -122.404779881684) | |||
146184 | 146184 | 30538 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 614 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 34538 | 6003619.86564688 | 2110438.7017887 | 37.775067091373295 | -122.43095343382099 | (37.7750670913733, -122.430953433821) | ||||
109018 | 109018 | 30843 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1375 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/1995 12:00:00 AM | Permit Number 34691 | 6011743.60320296 | 2101979.83639733 | 37.7522978969141 | -122.40225661865 | (37.7522978969141, -122.40225661865) | ||
91059 | 91059 | 30886 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1440 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 34718 | 6011020.35277298 | 2119822.53522602 | 37.8012494094877 | -122.40601460797501 | (37.8012494094877, -122.406014607975) | ||||
141323 | 141323 | 30890 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 412 Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/1995 12:00:00 AM | Permit Number 34719 | 6005865.19335847 | 2111068.58127823 | 37.7769235557198 | -122.423231126893 | (37.7769235557198, -122.423231126893) | |||
102110 | 102110 | 30891 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 412 Hayes St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/1995 12:00:00 AM | Permit Number 34719 | 6005865.19335847 | 2111068.58127823 | 37.7769235557198 | -122.423231126893 | (37.7769235557198, -122.423231126893) | |||
80869 | 80869 | 30892 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 412 Hayes St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/1995 12:00:00 AM | Permit Number 34719 | 6005865.19335847 | 2111068.58127823 | 37.7769235557198 | -122.423231126893 | (37.7769235557198, -122.423231126893) | |||
150299 | 150299 | 30926 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 230 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 13 | Permit Number 34739 | 5996065.71046 | 2091231.3003900002 | 37.7218974306099 | -122.455696079012 | (37.7218974306099, -122.455696079012) | |
134768 | 134768 | 30927 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 236 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 13 | Permit Number 34740 | 5996038.7385 | 2091232.9544799998 | 37.7219004244455 | -122.455789433158 | (37.7219004244455, -122.455789433158) | |
115455 | 115455 | 31210 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2736 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1995 12:00:00 AM | Permit Number 34902 | 6001624.16755345 | 2117801.03750222 | 37.7951689006516 | -122.43838455687201 | (37.7951689006516, -122.438384556872) | |||
96095 | 96095 | 31350 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 843 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | Permit Number 34960 | 6003828.78534548 | 2110731.50789971 | 37.7758829003399 | -122.43025162922702 | (37.7758829003399, -122.430251629227) | ||
77451 | 77451 | 31969 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 470 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/1995 12:00:00 AM | Permit Number 35370 | 6009517.59351868 | 2092163.53246737 | 37.725219944905895 | -122.40926189775499 | (37.7252199449059, -122.409261897755) | |||
116256 | 116256 | 32039 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3653 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1995 12:00:00 AM | Permit Number 35422 | 6003092.33534727 | 2120827.43015376 | 37.803561986725505 | -122.43352085652398 | (37.8035619867255, -122.433520856524) | |||
140871 | 140871 | 32046 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 501 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1999 12:00:00 AM | Permit Number 35428 | 6012610.0 | 2086139.0 | 37.7088505533644 | -122.398149216451 | (37.7088505533644, -122.398149216451) | ||
87790 | 87790 | 32047 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 501 Tunnel Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1999 12:00:00 AM | Permit Number 35428 | 6012610.0 | 2086139.0 | 37.7088505533644 | -122.398149216451 | (37.7088505533644, -122.398149216451) | ||
77427 | 77427 | 32868 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 456 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1996 12:00:00 AM | Permit Number 37214 | 6003519.04848512 | 2096396.05502281 | 37.736503601704996 | -122.430300092251 | (37.736503601705, -122.430300092251) | |||
96551 | 96551 | 33508 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 235 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37603 | 6006396.09682229 | 2098460.33665401 | 37.7423342020889 | -122.420499380726 | (37.7423342020889, -122.420499380726) | |||
116527 | 116527 | 33576 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 170 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | 18 | 2.5x4 | Permit Number 37684 | 6007080.60152815 | 2098048.2941617 | 37.7412413768938 | -122.41810336116998 | (37.7412413768938, -122.41810336117) | |
81512 | 81512 | 33580 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 161 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37688 | 6007154.09999929 | 2098074.89925627 | 37.7413185651373 | -122.417851114389 | (37.7413185651373, -122.417851114389) | |||
108242 | 108242 | 33581 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 159 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37689 | 6007159.65124857 | 2098085.1665824 | 37.7413470693377 | -122.417832647693 | (37.7413470693377, -122.417832647693) | |||
104502 | 104502 | 33585 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 220 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37693 | 6006929.36931778 | 2097797.05936052 | 37.740543028887295 | -122.418608458082 | (37.7405430288873, -122.418608458082) | |||
107629 | 107629 | 33588 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 184 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1996 12:00:00 AM | Permit Number 37695 | 6007041.74280393 | 2097976.42291715 | 37.741041847234 | -122.418232626766 | (37.741041847234, -122.418232626766) | |||
121898 | 121898 | 33589 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 180 Bonview St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1996 12:00:00 AM | Permit Number 37696 | 6007052.84530249 | 2097996.95756942 | 37.7410988557538 | -122.41819569379 | (37.7410988557538, -122.41819569379) | |||
140894 | 140894 | 33607 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 314 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37719 | 6005021.10976005 | 2110082.43632314 | 37.774168170123794 | -122.42608085228599 | (37.7741681701238, -122.426080852286) | |||
124129 | 124129 | 33609 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 308 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37721 | 6005048.76551317 | 2110086.28535746 | 37.774180301661794 | -122.42598546011699 | (37.7741803016618, -122.425985460117) | |||
111715 | 111715 | 33610 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 308 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37721 | 6005048.76551317 | 2110086.28535746 | 37.774180301661794 | -122.42598546011699 | (37.7741803016618, -122.425985460117) | |||
108270 | 108270 | 33611 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 310 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37722 | 6005039.5469288 | 2110085.00234602 | 37.774176257824394 | -122.42601725751001 | (37.7741762578244, -122.42601725751) | |||
143220 | 143220 | 33612 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 310 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37722 | 6005039.5469288 | 2110085.00234602 | 37.774176257824394 | -122.42601725751001 | (37.7741762578244, -122.42601725751) | |||
114237 | 114237 | 33613 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 386 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37723 | 6004689.24070975 | 2110036.24790961 | 37.7740225856392 | -122.42722555593299 | (37.7740225856392, -122.427225555933) | |||
141563 | 141563 | 33614 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 312 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37724 | 6005030.32834442 | 2110083.71933458 | 37.7741722139784 | -122.42604905489999 | (37.7741722139784, -122.4260490549) | |||
78322 | 78322 | 33615 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 312 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37724 | 6005030.32834442 | 2110083.71933458 | 37.7741722139784 | -122.42604905489999 | (37.7741722139784, -122.4260490549) | |||
123497 | 123497 | 33634 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 416 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37730 | 6005394.17412308 | 2110828.6660173 | 37.7762382136369 | -122.424843455434 | (37.7762382136369, -122.424843455434) | |||
106522 | 106522 | 33651 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 284 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37742 | 6006036.93235026 | 2110918.36759919 | 37.776520795938 | -122.422626351394 | (37.776520795938, -122.422626351394) | |||
20649 | 20649 | 33653 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 284 Linden St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37742 | 6006036.93235026 | 2110918.36759919 | 37.776520795938 | -122.422626351394 | (37.776520795938, -122.422626351394) | |||
49595 | 49595 | 33663 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 424 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37751 | 6005309.878255201 | 2111164.52643651 | 37.7771556428857 | -122.425158961888 | (37.7771556428857, -122.425158961888) | |||
107176 | 107176 | 33695 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 415 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37766 | 6005362.72010447 | 2111119.40531281 | 37.7770347362587 | -122.42497295397 | (37.7770347362587, -122.42497295397) | |||
123911 | 123911 | 33763 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1580 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | |||
91896 | 91896 | 33764 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1580 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | |||
125103 | 125103 | 33765 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1580 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | |||
84474 | 84474 | 33816 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1201 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | Permit Number 37831 | 6008598.80477101 | 2116262.85239853 | 37.791339665663294 | -122.414142270961 | (37.7913396656633, -122.414142270961) | |||
129073 | 129073 | 33817 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1201 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | Permit Number 37831 | 6008598.80477101 | 2116262.85239853 | 37.791339665663294 | -122.414142270961 | (37.7913396656633, -122.414142270961) | |||
144452 | 144452 | 33820 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1025 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/1984 12:00:00 AM | Permit Number 37834 | 6007679.68250964 | 2115084.43114941 | 37.7880523419006 | -122.417238879212 | (37.7880523419006, -122.417238879212) | |||
79999 | 79999 | 34142 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 400 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1997 12:00:00 AM | Permit Number 37990 | 6008524.65557539 | 2106230.12436926 | 37.7637880127631 | -122.41368889061701 | (37.7637880127631, -122.413688890617) | ||
141220 | 141220 | 34143 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 400 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1997 12:00:00 AM | Permit Number 37990 | 6008524.65557539 | 2106230.12436926 | 37.7637880127631 | -122.41368889061701 | (37.7637880127631, -122.413688890617) | ||
142937 | 142937 | 34145 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
128587 | 128587 | 34146 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
79197 | 79197 | 34147 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
105201 | 105201 | 34148 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
140363 | 140363 | 34149 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
102524 | 102524 | 34150 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
141849 | 141849 | 34151 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
87183 | 87183 | 34152 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
106914 | 106914 | 34153 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
104444 | 104444 | 34154 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
94880 | 94880 | 34155 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
103405 | 103405 | 34156 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
90068 | 90068 | 34157 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
80426 | 80426 | 34158 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
128323 | 128323 | 34159 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
74423 | 74423 | 34453 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1167 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 10 | Permit Number 38197 | 6007453.346609999 | 2118811.2297099996 | 37.798272471441706 | -122.418286300874 | (37.7982724714417, -122.418286300874) | |
114015 | 114015 | 34978 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 135 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1997 12:00:00 AM | Permit Number 38559 | 6002699.25501919 | 2105112.74476166 | 37.76039111075829 | -122.43375728104701 | (37.7603911107583, -122.433757281047) | |||
121302 | 121302 | 35055 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 570 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/1998 12:00:00 AM | Permit Number 38614 | 6008948.51314843 | 2105576.68374234 | 37.7620176073252 | -122.41217670641001 | (37.7620176073252, -122.41217670641) | ||
83973 | 83973 | 35231 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 402 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1998 12:00:00 AM | Permit Number 38724 | 6003567.92997574 | 2105934.61117361 | 37.7626970125211 | -122.430811591359 | (37.7626970125211, -122.430811591359) | |||
54737 | 54737 | 35236 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1198 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 10 | Permit Number 38733 | 6007268.58471 | 2119527.95161 | 37.80023000775871 | -122.418976495462 | (37.8002300077587, -122.418976495462) |
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");