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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
177119 | 177119 | 245470 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2700 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6010486.0542 | 2102262.08 | 37.753002599060295 | -122.40662533272899 | (37.7530025990603, -122.406625332729) | |||
177052 | 177052 | 142562 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2145 POWELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6009382.2185 | 2121078.4189 | 37.804605997205 | -122.41177208479999 | (37.804605997205, -122.4117720848) | |||
176947 | 176947 | 143345 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1814 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6004285.9025 | 2118759.7154 | 37.7979522227532 | -122.429242932847 | (37.7979522227532, -122.429242932847) | |||
176807 | 176807 | 140541 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1025 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003379.3786 | 2111825.8979 | 37.7788623586164 | -122.43188440296001 | (37.7788623586164, -122.43188440296) | |||
176802 | 176802 | 140630 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 808 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6003528.2379 | 2111115.3472 | 37.7769198002338 | -122.431318705355 | (37.7769198002338, -122.431318705355) | |||
176758 | 176758 | 138717 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1607 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999600.5215 | 2114397.0591 | 37.7857071588413 | -122.44514181900601 | (37.7857071588413, -122.445141819006) | |||
176578 | 176578 | 138502 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1799 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002532.1465 | 2114322.3247 | 37.7856688514425 | -122.43499389896499 | (37.7856688514425, -122.434993898965) | |||
176541 | 176541 | 143179 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 37 MIDWAY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6010057.031 | 2121502.7089 | 37.8058088248802 | -122.40946678446899 | (37.8058088248802, -122.409466784469) | |||
176490 | 176490 | 38608 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1570 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/2003 12:00:00 AM | 6 | Permit Number 45423 | 6015284.7491 | 2094285.2369 | 37.7313671428977 | -122.38947335260099 | (37.7313671428977, -122.389473352601) | |
176429 | 176429 | 30888 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 412 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/1995 12:00:00 AM | 19 | 4x4 | Permit Number 34719 | 6005821.6341 | 2111061.5148 | 37.7769016945255 | -122.4233813094 | (37.7769016945255, -122.4233813094) | |
176204 | 176204 | 143255 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 LOMBARD ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6009331.5401 | 2120459.4412 | 37.802903595680704 | -122.411903695843 | (37.8029035956807, -122.411903695843) | |||
176185 | 176185 | 201184 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 620 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6013400.7332 | 2113908.7797 | 37.78514447543571 | -122.397362434941 | (37.7851444754357, -122.397362434941) | |||
176172 | 176172 | 143339 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1862 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6004076.8152 | 2118728.5471 | 37.797854803733294 | -122.42996420993299 | (37.7978548037333, -122.429964209933) | |||
176087 | 176087 | 137986 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1826 WEBSTER ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6003453.629 | 2115096.2902 | 37.7878462437049 | -122.431861119013 | (37.7878462437049, -122.431861119013) | |||
176045 | 176045 | 199858 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2513 Keith St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6014132.4385 | 2092038.2943 | 37.7251335354362 | -122.393299957721 | (37.7251335354362, -122.393299957721) | |||
175898 | 175898 | 199982 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1081 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6018036.5838 | 2092513.2332 | 37.7266537566215 | -122.379836574534 | (37.7266537566215, -122.379836574534) | |||
175857 | 175857 | 140293 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 135 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998254.8738 | 2110151.3644 | 37.773972687525 | -122.449491324786 | (37.773972687525, -122.449491324786) | |||
175619 | 175619 | 244473 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 859 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003334.8057 | 2110313.6958 | 37.774707699745996 | -122.43193059003599 | (37.774707699746, -122.431930590036) | |||
175500 | 175500 | 140682 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 21366 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997596.5061 | 2110261.2804 | 37.7742368042101 | -122.451776648803 | (37.7742368042101, -122.451776648803) | |||
175434 | 175434 | 140536 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1099 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003366.6758 | 2111915.9993 | 37.779109034509204 | -122.43193478240102 | (37.7791090345092, -122.431934782401) | |||
175418 | 175418 | 143508 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1931 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003561.2395 | 2118662.3144 | 37.797643734119205 | -122.43174351417801 | (37.7976437341192, -122.431743514178) | |||
175350 | 175350 | 138007 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1803 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003877.7864 | 2114559.3667 | 37.7863960226531 | -122.43035529070801 | (37.7863960226531, -122.430355290708) | |||
175202 | 175202 | 63909 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2119 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1987 12:00:00 AM | 12 | Permit Number 24624 | 6009399.6734 | 2120957.786 | 37.804275748547504 | -122.41170315133301 | (37.8042757485475, -122.411703151333) | ||
175055 | 175055 | 59662 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 911 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1981 12:00:00 AM | 17 | Permit Number 19084 | 6002943.8621 | 2111474.7299 | 37.777873440392206 | -122.433365924976 | (37.7778734403922, -122.433365924976) | ||
174955 | 174955 | 199852 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2501 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6014213.4453 | 2092166.8088 | 37.7254909106612 | -122.393028911239 | (37.7254909106612, -122.393028911239) | |||
174864 | 174864 | 64376 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 69 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1988 12:00:00 AM | 11 | Permit Number 25215 | 5996673.1599 | 2112554.0417 | 37.7804791997483 | -122.45513636713801 | (37.7804791997483, -122.455136367138) | ||
174731 | 174731 | 143543 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2163 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002677.2113 | 2118490.3401 | 37.7971213870276 | -122.434790182952 | (37.7971213870276, -122.434790182952) | |||
174691 | 174691 | 140059 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 442 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6005650.7649 | 2111385.4165 | 37.7777814045245 | -122.423995437557 | (37.7777814045245, -122.423995437557) | |||
174672 | 174672 | 66381 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 648 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | 13 | Permit Number 29507 | 6003596.4072 | 2110594.4854 | 37.775493505524004 | -122.43104570278601 | (37.775493505524, -122.431045702786) | |
174319 | 174319 | 140069 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 582 GROVE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6005006.5887 | 2111294.3898 | 37.7774950779447 | -122.426217384893 | (37.7774950779447, -122.426217384893) | |||
174213 | 174213 | 137519 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 11 Seymour St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001649.8446 | 2112101.8284 | 37.7795217969961 | -122.437887303264 | (37.7795217969961, -122.437887303264) | |||
174092 | 174092 | 143542 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2163 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002663.4817 | 2118487.0712 | 37.7971116319851 | -122.434837456805 | (37.7971116319851, -122.434837456805) | |||
174033 | 174033 | 143523 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1931 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003741.1066 | 2118636.3409 | 37.7975826116174 | -122.43111927072901 | (37.7975826116174, -122.431119270729) | |||
173968 | 173968 | 246089 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 29 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998181.8595 | 2108411.1471 | 37.7691903195921 | -122.449618468841 | (37.7691903195921, -122.449618468841) | |||
173948 | 173948 | 140405 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003761.2248 | 2112532.0496 | 37.7808229146257 | -122.430613848284 | (37.7808229146257, -122.430613848284) | |||
173946 | 173946 | 138927 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 901 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003523.5494 | 2110764.9413 | 37.775957406614204 | -122.431309905462 | (37.7759574066142, -122.431309905462) | |||
173853 | 173853 | 143343 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1846 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6004153.4372 | 2118740.8845 | 37.797893018043 | -122.42969995673599 | (37.797893018043, -122.429699956736) | |||
173737 | 173737 | 143544 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2167 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6002631.4459 | 2118483.1484 | 37.797099042102396 | -122.434948027724 | (37.7970990421024, -122.434948027724) | |||
173501 | 173501 | 142596 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008359.2007 | 2120780.7848 | 37.8037313259866 | -122.415291263605 | (37.8037313259866, -122.415291263605) | |||
173380 | 173380 | 140446 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1435 EDDY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003632.9 | 2112791.8873 | 37.781529093472 | -122.43107633714399 | (37.781529093472, -122.431076337144) | |||
173338 | 173338 | 143166 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2130 STOCKTON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6009846.1251 | 2121530.2463 | 37.805872616224704 | -122.410198604722 | (37.8058726162247, -122.410198604722) | |||
173192 | 173192 | 142746 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 LOMBARD ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6009447.7459 | 2120475.7434 | 37.802954876200204 | -122.41150271469601 | (37.8029548762002, -122.411502714696) | |||
173135 | 173135 | 199722 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2300 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6015093.5789 | 2092222.3792 | 37.72569234746 | -122.38999022091998 | (37.72569234746, -122.38999022092) | |||
173043 | 173043 | 248359 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1485 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998647.9135 | 2108278.8108 | 37.768853609287206 | -122.44799689076099 | (37.7688536092872, -122.447996890761) | |||
172810 | 172810 | 246165 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1700 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5997526.8402 | 2108168.581 | 37.7684868003121 | -122.45186663191299 | (37.7684868003121, -122.451866631913) | |||
172803 | 172803 | 143014 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 488 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010067.5326 | 2120604.4864 | 37.8033431173057 | -122.409367013095 | (37.8033431173057, -122.409367013095) | |||
172505 | 172505 | 244507 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 480 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003680.127 | 2109976.8678 | 37.7738024231986 | -122.43071201293199 | (37.7738024231986, -122.430712012932) | |||
172304 | 172304 | 248308 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1327 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999347.2972 | 2108376.4732 | 37.76916171869029 | -122.445584804207 | (37.7691617186903, -122.445584804207) | |||
172173 | 172173 | 138587 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1732 BAKER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000059.0615 | 2114952.3738 | 37.7872580704829 | -122.44359531261298 | (37.7872580704829, -122.443595312613) | |||
172121 | 172121 | 142923 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1249 KEARNY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6011057.7598 | 2119245.0173 | 37.7996657782982 | -122.40584445833099 | (37.7996657782982, -122.405844458331) | |||
171990 | 171990 | 58122 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 24 Orben Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1978 12:00:00 AM | 13 | Permit Number 17103 | 6003170.2635 | 2115307.1662 | 37.7884091881086 | -122.43285658098499 | (37.7884091881086, -122.432856580985) | ||
171969 | 171969 | 56934 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1923 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1974 12:00:00 AM | 16 | 3x3 | Permit Number 14180 | 6001934.7565 | 2115177.2253 | 37.7879822517226 | -122.437121923696 | (37.7879822517226, -122.437121923696) | |
171803 | 171803 | 60926 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2000 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/1983 12:00:00 AM | 13 | Permit Number 20727 | 5989507.2134 | 2106536.1763 | 37.7635420716385 | -122.479486064031 | (37.7635420716385, -122.479486064031) | ||
171623 | 171623 | 141660 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 16 LOYOLA TER | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998448.6735 | 2110841.7689 | 37.775879445116104 | -122.448870682731 | (37.7758794451161, -122.448870682731) | |||
171567 | 171567 | 140062 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 907 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002950.6305 | 2111424.6435 | 37.7777362996085 | -122.43333893078301 | (37.7777362996085, -122.433338930783) | |||
171478 | 171478 | 61148 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2237 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/1983 12:00:00 AM | 7 | Permit Number 21005 | 5997050.2982 | 2110479.7459 | 37.7748053558267 | -122.453681848705 | (37.7748053558267, -122.453681848705) | ||
171470 | 171470 | 140525 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1190 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6003468.9224 | 2111772.2595 | 37.7787201566355 | -122.43157080528799 | (37.7787201566355, -122.431570805288) | |||
171426 | 171426 | 140142 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 208 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997849.5605 | 2109871.4122 | 37.773180816519606 | -122.450873174815 | (37.7731808165196, -122.450873174815) | |||
171375 | 171375 | 140068 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 582 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6005004.7286 | 2111303.2254 | 37.777519233201204 | -122.42622444880301 | (37.7775192332012, -122.426224448803) | |||
171274 | 171274 | 59153 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 20 Bellair Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/1982 12:00:00 AM | 11 | Permit Number 19779 | 6010063.4155 | 2121130.5341 | 37.8047872831513 | -122.40941840765801 | (37.8047872831513, -122.409418407658) | ||
171052 | 171052 | 142473 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1429 Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6010981.054 | 2119812.8124 | 37.8012205149436 | -122.40614991427499 | (37.8012205149436, -122.406149914275) | |||
170986 | 170986 | 141341 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 448 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001191.7822 | 2110294.5435 | 37.7745333908239 | -122.43934235241699 | (37.7745333908239, -122.439342352417) | |||
170725 | 170725 | 199724 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2300 Jennings St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6015054.2433 | 2092170.6809999999 | 37.7255482128528 | -122.390122592124 | (37.7255482128528, -122.390122592124) | |||
170504 | 170504 | 245138 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1320 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000087.6508 | 2109218.0834 | 37.7715148081993 | -122.443084420904 | (37.7715148081993, -122.443084420904) | |||
170435 | 170435 | 138716 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1609 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999594.5745 | 2114418.8648 | 37.7857666921726 | -122.445163962127 | (37.7857666921726, -122.445163962127) | |||
170427 | 170427 | 199732 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Armstrong Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014820.4695 | 2092191.1459 | 37.7255914365754 | -122.390932164611 | (37.7255914365754, -122.390932164611) | |||
170286 | 170286 | 137919 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1963 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6004551.2938 | 2115340.9969 | 37.788580310137 | -122.428080846949 | (37.788580310137, -122.428080846949) | |||
170251 | 170251 | 142629 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 725 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6009330.2372 | 2119895.0012 | 37.8013537106151 | -122.41186829545 | (37.8013537106151, -122.41186829545) | |||
170236 | 170236 | 244974 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 205 Rose St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005564.966 | 2109773.8307 | 37.7733515366804 | -122.424177602904 | (37.7733515366804, -122.424177602904) | |||
170210 | 170210 | 57646 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 666 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1981 12:00:00 AM | 16 | 7x7 | Permit Number 19439 | 6005402.5793 | 2111576.4092 | 37.7782918087921 | -122.424867589608 | (37.7782918087921, -122.424867589608) | |
170111 | 170111 | 115985 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 900 Kearny St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6011253.147999999 | 2118063.4049 | 37.7964322821358 | -122.405085093558 | (37.7964322821358, -122.405085093558) | |||
169803 | 169803 | 141307 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 61 COOK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5997486.7259 | 2113348.6561 | 37.7827076436193 | -122.452379230189 | (37.7827076436193, -122.452379230189) | |||
169792 | 169792 | 246387 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1356 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5999191.1888 | 2108399.0339 | 37.7692147510646 | -122.446126395439 | (37.7692147510646, -122.446126395439) | |||
169665 | 169665 | 143557 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 848 KEARNY ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6011271.7921 | 2117938.489 | 37.7960903354635 | -122.405011780806 | (37.7960903354635, -122.405011780806) | |||
169564 | 169564 | 200689 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 4705 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6015031.9275 | 2095672.1834 | 37.73516139610629 | -122.39044428404699 | (37.7351613961063, -122.390444284047) | |||
169493 | 169493 | 247449 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 919 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002569.9466 | 2109861.5161 | 37.773422736804 | -122.434544050831 | (37.773422736804, -122.434544050831) | |||
169358 | 169358 | 138119 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1700 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6x7 | 6004323.0329 | 2114669.3641 | 37.786723258345 | -122.42882269508002 | (37.786723258345, -122.42882269508) | |||
169351 | 169351 | 140065 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 612 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6005425.1416 | 2111379.12 | 37.777751375190604 | -122.424775499228 | (37.7777513751906, -122.424775499228) | |||
169263 | 169263 | 33692 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 401 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 11 | Permit Number 37765 | 6005361.9877 | 2111137.3022 | 37.7770838353758 | -122.42497676123001 | (37.7770838353758, -122.42497676123) | ||
168944 | 168944 | 140051 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 501 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005299.4561 | 2111632.5014 | 37.7784399990073 | -122.42522832358 | (37.7784399990073, -122.42522832358) | |||
168873 | 168873 | 140508 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1020 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003419.5462 | 2111864.9347 | 37.778971820925996 | -122.43174823532401 | (37.778971820926, -122.431748235324) | |||
168674 | 168674 | 138419 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1819 STEINER ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 0ft | 6002518.3631 | 2114471.7689 | 37.7860784045808 | -122.435052277699 | (37.7860784045808, -122.435052277699) | |||
168656 | 168656 | 142933 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 502 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6011075.0739 | 2119008.1155 | 37.7990162718949 | -122.405767848781 | (37.7990162718949, -122.405767848781) | |||
168607 | 168607 | 142488 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 651 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6009640.0611 | 2119612.4195 | 37.800595187798294 | -122.410776194648 | (37.8005951877983, -122.410776194648) | |||
168438 | 168438 | 245420 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2855 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6009712.0846 | 2102179.2059 | 37.7527317128259 | -122.409296032004 | (37.7527317128259, -122.409296032004) | |||
168437 | 168437 | 244244 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 150 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6005791.8047 | 2110016.6014 | 37.7740309317752 | -122.423410197258 | (37.7740309317752, -122.423410197258) | |||
168121 | 168121 | 248309 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1333 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999321.5567 | 2108373.142 | 37.769151102475 | -122.445673599246 | (37.769151102475, -122.445673599246) | |||
168080 | 168080 | 141679 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2340 TURK BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998783.9983 | 2111836.4043 | 37.778629628102 | -122.44778233403 | (37.778629628102, -122.44778233403) | |||
167934 | 167934 | 138421 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1819 STEINER ST | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 0ft | 6002523.7545 | 2114441.5771 | 37.7859958117094 | -122.435031464821 | (37.7859958117094, -122.435031464821) | |||
167853 | 167853 | 32297 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1616 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | 12 | Permit Number 36875 | 6011502.2034 | 2107015.4172 | 37.766111004805396 | -122.40344565674499 | (37.7661110048054, -122.403445656745) | ||
167676 | 167676 | 142591 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008291.5451 | 2120841.4416 | 37.8038940717069 | -122.41552968724 | (37.8038940717069, -122.41552968724) | |||
167539 | 167539 | 248335 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1559 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998127.3503 | 2108207.3431 | 37.768627607196 | -122.449792323102 | (37.768627607196, -122.449792323102) | |||
167397 | 167397 | 142113 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1270 GROVE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6001736.8029 | 2110836.8034 | 37.7760533014164 | -122.437495863249 | (37.7760533014164, -122.437495863249) | |||
167223 | 167223 | 246096 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997106.9677 | 2108216.5794 | 37.768594534360204 | -122.453322392223 | (37.7685945343602, -122.453322392223) | |||
167163 | 167163 | 142073 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 419 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6001163.9737 | 2110159.9703 | 37.774162304079 | -122.439428898655 | (37.774162304079, -122.439428898655) | |||
167141 | 167141 | 143367 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1757 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6004589.7934 | 2118755.8193 | 37.7979587239783 | -122.428191105617 | (37.7979587239783, -122.428191105617) | |||
167113 | 167113 | 143354 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1651 UNION ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6005214.4581 | 2118841.5322 | 37.798229393632205 | -122.42603569078501 | (37.7982293936322, -122.426035690785) | |||
167093 | 167093 | 143524 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2240 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002241.7862 | 2118472.6878 | 37.7970481880141 | -122.436295594804 | (37.7970481880141, -122.436295594804) | |||
167047 | 167047 | 143522 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2230 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6002288.2054 | 2118479.2257 | 37.7970687767232 | -122.436135441431 | (37.7970687767232, -122.436135441431) | |||
167035 | 167035 | 142595 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008339.7594 | 2120798.6708 | 37.803779343791795 | -122.415359808453 | (37.8037793437918, -122.415359808453) |
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");