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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
122027 | 122027 | 224650 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 24 Prospect Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6007190.04837 | 2099393.66184 | 37.744941615564706 | -122.417820274 | (37.7449416155647, -122.417820274) | |||
129648 | 129648 | 224510 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1198 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6007627.9779199995 | 2102718.14058 | 37.7540945196695 | -122.416541439837 | (37.7540945196695, -122.416541439837) | |||
137325 | 137325 | 176405 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 75 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 2ft | 5998552.29871 | 2087983.35456 | 37.7131217039812 | -122.446867014517 | (37.7131217039812, -122.446867014517) | |||
158078 | 158078 | 224533 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3143 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6008085.98241 | 2102084.65077 | 37.7523808471161 | -122.41491271097 | (37.7523808471161, -122.41491271097) | |||
169405 | 169405 | 226499 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 133 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6005600.01114 | 2099028.12585 | 37.7438483268298 | -122.42329235906999 | (37.7438483268298, -122.42329235907) | |||
175191 | 175191 | 224633 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 196 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6007335.08307 | 2097320.51793 | 37.739257384923704 | -122.41717189426599 | (37.7392573849237, -122.417171894266) | |||
178689 | 178689 | 226475 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3160 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6008399.696219999 | 2105072.76604 | 37.760603155239295 | -122.41403920664301 | (37.7606031552393, -122.414039206643) | |||
181334 | 181334 | 224503 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 111 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6006785.203840001 | 2096905.7488900002 | 37.7380875710875 | -122.41904372338301 | (37.7380875710875, -122.419043723383) | |||
1961 | 1961 | 224699 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3230 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 3ft | 6007526.74961 | 2102095.6735900003 | 37.7523796734842 | -122.416847415286 | (37.7523796734842, -122.416847415286) | |||
2216 | 2216 | 122752 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 693 Vermont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 6011278.80569 | 2105286.3398 | 37.7613508668666 | -122.404096651066 | (37.7613508668666, -122.404096651066) | |||
13606 | 13606 | 6798 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1375 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x9 | 6016915.23611 | 2097187.56543 | 37.7394266247399 | -122.38403843113701 | (37.7394266247399, -122.384038431137) | |||
16905 | 16905 | 26220 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 765X San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6005701.2867 | 2098677.11468 | 37.7428902448864 | -122.422917229343 | (37.7428902448864, -122.422917229343) | |||
17077 | 17077 | 551 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2900 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6009445.64374 | 2102206.2231799997 | 37.752790964934704 | -122.41021934346 | (37.7527909649347, -122.41021934346) | |||
17372 | 17372 | 552 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2904 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009418.497 | 2102204.07854 | 37.7527835545272 | -122.41031307080699 | (37.7527835545272, -122.410313070807) | |||
17445 | 17445 | 16902 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 427 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004930.51635 | 2110189.46412 | 37.7744569217764 | -122.42640185318899 | (37.7744569217764, -122.426401853189) | |||
17601 | 17601 | 577 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3024 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008801.63126 | 2102168.54838 | 37.752651398249604 | -122.41244380126301 | (37.7526513982496, -122.412443801263) | |||
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) | |||
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) | |||
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) | |||
18516 | 18516 | 580 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3013 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008848.9981 | 2102129.16474 | 37.7525459176681 | -122.412277214445 | (37.7525459176681, -122.412277214445) | |||
18722 | 18722 | 576 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3008 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008852.23919 | 2102169.31321 | 37.7526563382221 | -122.412268843556 | (37.7526563382221, -122.412268843556) | |||
19855 | 19855 | 602 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3085 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x5 | 6008423.83472 | 2102105.59165 | 37.7524573245683 | -122.413745839724 | (37.7524573245683, -122.413745839724) | |||
19889 | 19889 | 597 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3067 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008545.44191 | 2102115.03145 | 37.7524900724667 | -122.41332596783998 | (37.7524900724667, -122.41332596784) | |||
20042 | 20042 | 24448 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1156 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006348.61536 | 2102840.94797 | 37.7543596874688 | -122.420974512988 | (37.7543596874688, -122.420974512988) | |||
20104 | 20104 | 26548 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3085 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6008470.90767 | 2102107.16108 | 37.752464277228 | -122.41358316405399 | (37.752464277228, -122.413583164054) | |||
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) | |||
20144 | 20144 | 16900 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 409 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005007.3916 | 2110203.70331 | 37.774500364432505 | -122.426136940772 | (37.7745003644325, -122.426136940772) | |||
20206 | 20206 | 5338 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 158 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x5 | 6004769.98156 | 2107435.4149 | 37.766885892799 | -122.426761005535 | (37.766885892799, -122.426761005535) | |||
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) | |||
20360 | 20360 | 611 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3108 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008224.09237 | 2102134.47643 | 37.752525416718 | -122.41443862795799 | (37.752525416718, -122.414438627958) | |||
20802 | 20802 | 574 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3000 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x6 | 6008882.07656 | 2102170.50291 | 37.7526612791072 | -122.412165744373 | (37.7526612791072, -122.412165744373) | |||
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) | |||
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) | |||
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) | |||
21969 | 21969 | 556 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2934 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6009338.079419999 | 2102203.4712799997 | 37.7527773788967 | -122.410591127672 | (37.7527773788967, -122.410591127672) | |||
26601 | 26601 | 224669 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6009345.52709 | 2104457.09364 | 37.758965736194504 | -122.410724513338 | (37.7589657361945, -122.410724513338) | |||
32026 | 32026 | 224492 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 60 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5998346.422619999 | 2106894.64873 | 37.7650358128629 | -122.448940002185 | (37.7650358128629, -122.448940002185) | |||
33348 | 33348 | 224580 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6008616.559830001 | 2106802.76672 | 37.765365516923396 | -122.413411521233 | (37.7653655169234, -122.413411521233) | |||
42614 | 42614 | 176421 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 526 Lathrop Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6013003.58559 | 2086544.76512 | 37.7099866196603 | -122.396817348641 | (37.7099866196603, -122.396817348641) | |||
42648 | 42648 | 226500 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 155 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6005540.15432 | 2099025.50317 | 37.743837747220894 | -122.423499143787 | (37.7438377472209, -122.423499143787) | |||
48883 | 48883 | 224661 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 602 Alabama St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6008966.38412 | 2105242.83972 | 37.7611019507102 | -122.41209130299801 | (37.7611019507102, -122.412091302998) | |||
51013 | 51013 | 224707 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3128 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6008124.010419999 | 2102718.1378200003 | 37.7541223959334 | -122.414826033413 | (37.7541223959334, -122.414826033413) | |||
64922 | 64922 | 224573 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3145 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6008576.89617 | 2105622.59644 | 37.76212281432579 | -122.413465236845 | (37.7621228143258, -122.413465236845) | |||
66518 | 66518 | 224643 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 7 Heyman Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6006383.19422 | 2098395.0871099997 | 37.742154314365 | -122.420539363423 | (37.742154314365, -122.420539363423) | |||
69939 | 69939 | 224544 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3275 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6006493.53291 | 2103755.0998299997 | 37.7568779051989 | -122.420538236555 | (37.7568779051989, -122.420538236555) | |||
75837 | 75837 | 126622 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3340 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5998235.513119999 | 2116198.50625 | 37.7905754501486 | -122.449994218979 | (37.7905754501486, -122.449994218979) | |||
82229 | 82229 | 75088 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 574 WALLER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/1985 12:00:00 AM | 18 | 5x5 | 6002936.0 | 2108949.0 | 37.7709379654477 | -122.433212606655 | (37.7709379654477, -122.433212606655) | ||
97890 | 97890 | 104423 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2362 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 18 | 3x3 | Permit Number 24809 | 6002031.0 | 2107070.0 | 37.7657273142687 | -122.436208531898 | (37.7657273142687, -122.436208531898) | |
101311 | 101311 | 62353 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 113 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1985 12:00:00 AM | 18 | Permit Number 22497 | 6005157.02914158 | 2099582.1696783 | 37.7453445941022 | -122.42486349755501 | (37.7453445941022, -122.424863497555) | |
113951 | 113951 | 64051 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2362 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1987 12:00:00 AM | 18 | 3x3 | Permit Number 24809 | 6001958.39518673 | 2107077.48794504 | 37.765743748959295 | -122.436460191864 | (37.7657437489593, -122.436460191864) |
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) | |
124492 | 124492 | 64582 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3646 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1988 12:00:00 AM | 18 | 7x12 | Permit Number 25481 | 6005989.81318517 | 2104358.59934784 | 37.758506573723004 | -122.42232316712901 | (37.758506573723, -122.422323167129) | |
125826 | 125826 | 104403 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2362 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 18 | 3x3 | Permit Number 24809 | 6002031.0 | 2107070.0 | 37.7657273142687 | -122.436208531898 | (37.7657273142687, -122.436208531898) | |
137467 | 137467 | 58912 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2308 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/1980 12:00:00 AM | 18 | Permit Number 776948 | 6001885.650830001 | 2118771.72016 | 37.7978490112876 | -122.437549333047 | (37.7978490112876, -122.437549333047) | ||
157746 | 157746 | 112160 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1328 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6013587.23518 | 2105720.84823 | 37.7626726418425 | -122.396143156607 | (37.7626726418425, -122.396143156607) | |||
167351 | 167351 | 226478 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3160 19th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6008300.96502 | 2105069.13983 | 37.760587652724396 | -122.41438041754 | (37.7605876527244, -122.41438041754) | |||
172582 | 172582 | 224655 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 144 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6006439.43826 | 2097444.91016 | 37.7395485107564 | -122.42027746554 | (37.7395485107564, -122.42027746554) | |||
182441 | 182441 | 224648 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 26 Heyman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6006463.11483 | 2098326.0770400004 | 37.7419693319081 | -122.420258125606 | (37.7419693319081, -122.420258125606) | |||
187559 | 187559 | 224649 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 24 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6007194.88444 | 2099407.51056 | 37.7449799131997 | -122.41780453317 | (37.7449799131997, -122.41780453317) | |||
2011 | 2011 | 224701 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3230 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 3ft | 6007503.74003 | 2102097.0446900004 | 37.7523821439458 | -122.416927083514 | (37.7523821439458, -122.416927083514) | |||
32870 | 32870 | 224543 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3257 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6006596.438630001 | 2103760.0556900003 | 37.7568973116766 | -122.420182701267 | (37.7568973116766, -122.420182701267) | |||
42340 | 42340 | 224585 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6008501.81805 | 2106792.30192 | 37.765330339934295 | -122.413807647409 | (37.7653303399343, -122.413807647409) | |||
43163 | 43163 | 249545 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 298 Myrtle St | 2 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6006121.634219999 | 2114038.6036799997 | 37.7850929805917 | -122.42255511555099 | (37.7850929805917, -122.422555115551) | |||
46243 | 46243 | 224511 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1117 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6009227.24206 | 2102557.50534 | 37.7537432624556 | -122.410999428875 | (37.7537432624556, -122.410999428875) | |||
48186 | 48186 | 224539 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2925 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6008666.00775 | 2103876.41315 | 37.7573331968792 | -122.413033560461 | (37.7573331968792, -122.413033560461) | |||
53537 | 53537 | 224668 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6009343.82267 | 2104472.74899 | 37.7590086266741 | -122.410731513656 | (37.7590086266741, -122.410731513656) | |||
59560 | 59560 | 249546 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 298 Myrtle St | 3 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6006094.99565 | 2114034.77585 | 37.785080967461795 | -122.422647004665 | (37.7850809674618, -122.422647004665) | |||
65193 | 65193 | 224571 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3235 18th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6008059.06529 | 2105594.02225 | 37.7620152671241 | -122.41525419791799 | (37.7620152671241, -122.415254197918) | |||
77245 | 77245 | 226480 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3160 19th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6008258.38904 | 2105066.62295 | 37.7605783501336 | -122.414527490854 | (37.7605783501336, -122.414527490854) | |||
78272 | 78272 | 106690 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 98X CHATTANOOGA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 4x4 | 6004701.0 | 2103385.0 | 37.7557605147563 | -122.426711131232 | (37.7557605147563, -122.426711131232) | |||
136908 | 136908 | 224676 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 123 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007744.73276 | 2107219.6910599996 | 37.766461304874 | -122.416456511479 | (37.766461304874, -122.416456511479) | |||
137984 | 137984 | 224483 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1500 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6007282.9352400005 | 2107366.34912 | 37.766838012891704 | -122.418064187227 | (37.7668380128917, -122.418064187227) | |||
148521 | 148521 | 226488 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2498 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6008832.88031 | 2103985.45214 | 37.757641959338706 | -122.41246415471001 | (37.7576419593387, -122.41246415471) | |||
150673 | 150673 | 224557 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3349 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007922.950540001 | 2104420.2631099997 | 37.758784744042 | -122.415641857896 | (37.758784744042, -122.415641857896) | |||
158006 | 158006 | 126625 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1445 Sansome St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6011819.79643 | 2120570.04508 | 37.8033465696629 | -122.40330078161101 | (37.8033465696629, -122.403300781611) | |||
160486 | 160486 | 224508 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2201 Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6008177.844880001 | 2105327.1946400004 | 37.761289294789 | -122.414824499172 | (37.761289294789, -122.414824499172) | |||
160894 | 160894 | 224606 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 73 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6005880.9879 | 2103425.9555900004 | 37.7559396119431 | -122.42263325944201 | (37.7559396119431, -122.422633259442) | |||
174003 | 174003 | 126627 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6013882.15291 | 2118048.61881 | 37.796538299751 | -122.39598707025499 | (37.796538299751, -122.395987070255) | |||
175419 | 175419 | 224660 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 602 Alabama St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6008966.9840400005 | 2105222.67226 | 37.761046609131895 | -122.41208780281 | (37.7610466091319, -122.41208780281) | |||
175679 | 175679 | 224635 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 159 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007212.97385 | 2098214.14312 | 37.7417042108849 | -122.417657415761 | (37.7417042108849, -122.417657415761) | |||
176422 | 176422 | 226481 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3235 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6007993.239469999 | 2105048.9001700003 | 37.7605147878543 | -122.415443270504 | (37.7605147878543, -122.415443270504) | |||
183406 | 183406 | 224652 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 50 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007400.925369999 | 2098998.39155 | 37.74386815689579 | -122.41706309608601 | (37.7438681568958, -122.417063096086) | |||
9838 | 9838 | 68204 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1110 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 16 | 3x3 | Permit Number 32363 | 6009978.53990017 | 2102725.22931804 | 37.754245896491604 | -122.408413088762 | (37.7542458964916, -122.408413088762) |
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) | |||
29802 | 29802 | 224567 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3235 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007896.19994 | 2105583.80933 | 37.7619780702545 | -122.41581676433701 | (37.7619780702545, -122.415816764337) | |||
43376 | 43376 | 176420 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 526 Lathrop Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6012864.549880001 | 2086589.64347 | 37.7101021070033 | -122.397301031027 | (37.7101021070033, -122.397301031027) | |||
43555 | 43555 | 224584 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008542.99689 | 2106795.22797 | 37.76534068665 | -122.41366542593799 | (37.76534068665, -122.413665425938) | |||
44782 | 44782 | 224499 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 35 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6007169.2602 | 2099278.27912 | 37.744623630583 | -122.41788397836599 | (37.744623630583, -122.417883978366) | |||
46078 | 46078 | 224507 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2201 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6008190.11914 | 2105143.7552799997 | 37.760786302161996 | -122.414769064951 | (37.760786302162, -122.414769064951) | |||
47182 | 47182 | 224514 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 439 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007856.97968 | 2105196.19408 | 37.760911563330296 | -122.415924962689 | (37.7609115633303, -122.415924962689) | |||
48272 | 48272 | 224596 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3395 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6005741.73742 | 2103713.82749 | 37.7567221840006 | -122.423135295184 | (37.7567221840006, -122.423135295184) | |||
53817 | 53817 | 224489 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 24 Alma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5998519.39636 | 2106289.8820599997 | 37.763385166627295 | -122.44829817853399 | (37.7633851666273, -122.448298178534) | |||
55000 | 55000 | 224574 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3143 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008595.85169 | 2105623.97585 | 37.7621276661759 | -122.4133997743 | (37.7621276661759, -122.4133997743) | |||
55200 | 55200 | 224518 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 439 Shotwell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007850.1916 | 2105341.72368 | 37.7613107723984 | -122.41595874569401 | (37.7613107723984, -122.415958745694) | |||
55616 | 55616 | 226483 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3470 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6006409.05576 | 2104966.19294 | 37.7601985241524 | -122.420916373596 | (37.7601985241524, -122.420916373596) | |||
62024 | 62024 | 126626 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 350 Washington St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 8ft | 6013909.986409999 | 2118052.46146 | 37.796550399249796 | -122.39589102894399 | (37.7965503992498, -122.395891028944) | |||
70379 | 70379 | 224505 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2200 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6008118.04648 | 2105348.76718 | 37.7613451678544 | -122.415032844197 | (37.7613451678544, -122.415032844197) | |||
72573 | 72573 | 224604 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 26 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6005971.507680001 | 2103476.95331 | 37.756084746337294 | -122.42232383507299 | (37.7560847463373, -122.422323835073) | |||
73696 | 73696 | 224598 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3375 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6005862.87598 | 2103720.88852 | 37.756748407333795 | -122.422716854995 | (37.7567484073338, -122.422716854995) | |||
74404 | 74404 | 226477 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3160 19th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008318.01409 | 2105071.04935 | 37.7605938535523 | -122.414321587482 | (37.7605938535523, -122.414321587482) |
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");