trees
969 rows where qSpecies_id = 97 sorted by Zip Codes descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes ▲ | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24672 | 218819 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 205 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5991410.90841 | 2090573.24495 | 37.7198223438984 | -122.471738457278 | (37.7198223438984, -122.471738457278) | 9 | 8 | 6 | 64 | 24 | |||
| 50071 | 218822 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 210 Vernon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5992480.53035 | 2089289.94219 | 37.7163605349795 | -122.467947888583 | (37.7163605349795, -122.467947888583) | 9 | 8 | 6 | 64 | 24 | |||
| 53327 | 176434 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 109 Chester Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991752.24555 | 2088448.0917 | 37.714006934552 | -122.47040389842 | (37.714006934552, -122.47040389842) | 9 | 8 | 6 | 64 | 24 | |||
| 71226 | 218821 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 278 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5991714.63996 | 2090365.57714 | 37.719269707816 | -122.470673455841 | (37.719269707816, -122.470673455841) | 9 | 8 | 6 | 64 | 24 | |||
| 103243 | 218824 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 104 Vernon St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 5992465.47636 | 2088577.72346 | 37.7144040850433 | -122.467948147585 | (37.7144040850433, -122.467948147585) | 9 | 8 | 6 | 64 | 24 | |||
| 147151 | 218826 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 354 Head St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5993503.05802 | 2088221.25741 | 37.713485177561 | -122.46433601702 | (37.713485177561, -122.46433601702) | 9 | 8 | 6 | 64 | 24 | |||
| 149904 | 218823 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 122 Vernon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5992474.68721 | 2088695.04537 | 37.7147267546141 | -122.467924839857 | (37.7147267546141, -122.467924839857) | 9 | 8 | 6 | 64 | 24 | |||
| 161624 | 218820 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 205 Beverly St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5991411.7286 | 2090565.37313 | 37.7198007772708 | -122.471735048829 | (37.7198007772708, -122.471735048829) | 9 | 8 | 6 | 64 | 24 | |||
| 169776 | 218825 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 295 Bright St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 5993731.49381 | 2089150.28883 | 37.7160492409447 | -122.463613852416 | (37.7160492409447, -122.463613852416) | 9 | 8 | 6 | 64 | 24 | |||
| 184895 | 218827 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 15 Rossmoor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5991236.4555 | 2094303.51433 | 37.7300546412872 | -122.472613299773 | (37.7300546412872, -122.472613299773) | 9 | 8 | 4 | 64 | 40 | |||
| 189517 | 176433 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 118 Chester Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5991720.02905 | 2088438.70148 | 37.7139792884876 | -122.470514566313 | (37.7139792884876, -122.470514566313) | 9 | 8 | 6 | 64 | 24 | |||
| 7928 | 5672 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1422 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6005185.06241 | 2100046.61651 | 37.7466214421279 | -122.424799598532 | (37.7466214421279, -122.424799598532) | 2 | 7 | 5 | 63 | 22 | |||
| 20637 | 50305 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1217@ ARMY Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/2003 12:00:00 AM | Permit Number 47015 | 6001375.35048187 | 2100228.68999583 | 37.7469054591013 | -122.437986196494 | (37.7469054591013, -122.437986196494) | 2 | 4 | 5 | 63 | 22 | ||
| 29378 | 62357 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 172 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22501 | 6004773.71147679 | 2099613.16071739 | 37.745408029937 | -122.426191153847 | (37.745408029937, -122.426191153847) | 2 | 7 | 5 | 63 | 22 | ||
| 36246 | 32868 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 456 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1996 12:00:00 AM | Permit Number 37214 | 6003519.04848512 | 2096396.05502281 | 37.736503601705 | -122.430300092251 | (37.736503601705, -122.430300092251) | 2 | 7 | 5 | 63 | 7 | |||
| 40903 | 224617 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 970 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999693.04498 | 2101841.13049 | 37.7512370173901 | -122.443919267953 | (37.7512370173901, -122.443919267953) | 2 | 5 | 5 | 63 | 38 | |||
| 42082 | 62352 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 102 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22496 | 6005217.58297735 | 2099637.57957653 | 37.7455001571003 | -122.424658053081 | (37.7455001571003, -122.424658053081) | 2 | 7 | 5 | 63 | 22 | ||
| 45208 | 60434 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 461 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/07/1987 12:00:00 AM | Permit Number 24099 | 6003594.47944671 | 2098910.74347696 | 37.7434126315981 | -122.430218644192 | (37.7434126315981, -122.430218644192) | 2 | 7 | 5 | 63 | 22 | ||
| 60366 | 64334 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 18 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25162 | 6004243.25196821 | 2098226.95980835 | 37.7415718437352 | -122.427926638771 | (37.7415718437352, -122.427926638771) | 2 | 7 | 5 | 63 | 7 | ||
| 69005 | 62360 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 198 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22505 | 6004608.84494602 | 2099604.09085689 | 37.7453738062021 | -122.426760590215 | (37.7453738062021, -122.426760590215) | 2 | 7 | 5 | 63 | 22 | ||
| 74301 | 1923 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 78 Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6001189.66062 | 2097346.80979 | 37.7389819342562 | -122.438421854409 | (37.7389819342562, -122.438421854409) | 2 | 7 | 5 | 63 | 7 | |||
| 76333 | 224613 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 525 Burnett Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5999489.63243 | 2102445.23523 | 37.7528841365055 | -122.44466610455 | (37.7528841365055, -122.44466610455) | 2 | 5 | 5 | 63 | 38 | |||
| 96644 | 59421 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 59 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25134 | 6004314.38183356 | 2097887.85689933 | 37.7406447683968 | -122.42765654127 | (37.7406447683968, -122.42765654127) | 2 | 7 | 5 | 63 | 7 | ||
| 100196 | 224611 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 525 Burnett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999479.68357 | 2102426.58534 | 37.7528323607352 | -122.444699169054 | (37.7528323607352, -122.444699169054) | 2 | 5 | 5 | 63 | 38 | |||
| 100467 | 62353 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 113 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | 18 | Permit Number 22497 | 6005157.02914158 | 2099582.1696783 | 37.7453445941022 | -122.424863497555 | (37.7453445941022, -122.424863497555) | 2 | 7 | 5 | 63 | 22 | |
| 102790 | 224610 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 87 Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000904.1974 | 2097866.66824 | 37.7403931018552 | -122.439446107557 | (37.7403931018552, -122.439446107557) | 2 | 7 | 5 | 63 | 7 | |||
| 106260 | 218807 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 238 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5999815.89022 | 2094384.28046 | 37.7307692875673 | -122.442959015043 | (37.7307692875673, -122.442959015043) | 9 | 7 | 4 | 63 | 40 | |||
| 109653 | 173730 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 387 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999535 | 2094919 | 37.7322214835803 | -122.443968498715 | (37.7322214835803, -122.443968498715) | 9 | 7 | 4 | 63 | 40 | ||||
| 115391 | 224618 | Planning Code 138.1 required 2 | Ficus microcarpa :: Chinese Banyan 97 | 165 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 3ft | Permit Number 780743 | 6001936.24436 | 2096476.10277 | 37.7366336128599 | -122.435778235198 | (37.7366336128599, -122.435778235198) | 2 | 7 | 5 | 63 | 7 | ||
| 118335 | 64335 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 148 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25163 | 6004614.99091661 | 2097575.59980235 | 37.7398043808352 | -122.426594919866 | (37.7398043808352, -122.426594919866) | 2 | 7 | 5 | 63 | 7 | ||
| 120716 | 1351 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 271 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5999796.36324 | 2099302.32917 | 37.7442719740833 | -122.443379644158 | (37.7442719740833, -122.443379644158) | 2 | 7 | 5 | 63 | 22 | |||
| 124265 | 22835 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 104 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/1994 12:00:00 AM | 20 | 2X2 | 5999575.13645 | 2098938.39255 | 37.7432600730945 | -122.444118450719 | (37.7432600730945, -122.444118450719) | 2 | 7 | 5 | 63 | 7 | ||
| 127710 | 224614 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 525 Burnett Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999496.34966 | 2102468.38313 | 37.7529480782956 | -122.444644538818 | (37.7529480782956, -122.444644538818) | 2 | 5 | 5 | 63 | 38 | |||
| 128200 | 66311 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 140 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29426 | 6001329.17242898 | 2095394.93152934 | 37.7336304648573 | -122.437799727546 | (37.7336304648573, -122.437799727546) | 9 | 7 | 5 | 63 | 40 | ||
| 131423 | 5670 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1416 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6005182.49595 | 2100071.1312 | 37.7466886088884 | -122.424810216828 | (37.7466886088884, -122.424810216828) | 2 | 7 | 5 | 63 | 22 | |||
| 135040 | 64333 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 21 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25161 | 6004296.86075631 | 2098199.7784306 | 37.741500242556 | -122.427739341515 | (37.741500242556, -122.427739341515) | 2 | 7 | 5 | 63 | 7 | ||
| 136653 | 5127 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2764 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/18/1994 12:00:00 AM | 15 | 3X3 | 6002472.72131 | 2095943.62285 | 37.7352020045603 | -122.433885356532 | (37.7352020045603, -122.433885356532) | 2 | 7 | 5 | 63 | 7 | ||
| 143478 | 224612 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 525 Burnett Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5999484.75601 | 2102435.63345 | 37.7528574940932 | -122.444682277976 | (37.7528574940932, -122.444682277976) | 2 | 5 | 5 | 63 | 38 | |||
| 144232 | 5748 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1770 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 5X5 | 6005291.42369 | 2098088.82872 | 37.7412518096224 | -122.424292591354 | (37.7412518096224, -122.424292591354) | 2 | 7 | 5 | 63 | 7 | |||
| 153957 | 5685 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1506 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 5x5 | 6005209.87097 | 2099535.96992 | 37.7452207246578 | -122.424677493096 | (37.7452207246578, -122.424677493096) | 2 | 7 | 5 | 63 | 22 | |||
| 160997 | 64287 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 359 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25092 | 6004210.28159871 | 2098359.34465346 | 37.7419334769159 | -122.428050070914 | (37.7419334769159, -122.428050070914) | 2 | 7 | 5 | 63 | 7 | ||
| 162342 | 60432 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 447 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31498 | 6003680.70369729 | 2098915.54804456 | 37.7434307072212 | -122.42992084535 | (37.7434307072212, -122.42992084535) | 2 | 7 | 5 | 63 | 22 | ||
| 166304 | 224616 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 525 Burnett Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999502.23945 | 2102489.21916 | 37.7530056250346 | -122.444625668335 | (37.7530056250346, -122.444625668335) | 2 | 5 | 5 | 63 | 38 | |||
| 183317 | 5133 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2796 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6002464.77756 | 2095726.89475 | 37.7346064681217 | -122.433897334607 | (37.7346064681217, -122.433897334607) | 2 | 7 | 5 | 63 | 7 | |||
| 183797 | 224615 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 525 Burnett Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999500.0818 | 2102479.17274 | 37.7529779168973 | -122.444632407852 | (37.7529779168973, -122.444632407852) | 2 | 5 | 5 | 63 | 38 | |||
| 189826 | 218806 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 217 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5999893.77638 | 2094346.53737 | 37.7306700941413 | -122.44268704209 | (37.7306700941413, -122.44268704209) | 9 | 7 | 4 | 63 | 40 | |||
| 189934 | 64807 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 74 Newburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25809 | 6002370.48571479 | 2099839.6903707 | 37.7458938988463 | -122.434517304917 | (37.7458938988463, -122.434517304917) | 2 | 7 | 5 | 63 | 22 | ||
| 42835 | 218840 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 18 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992943.37066 | 2098991.78527 | 37.7430261153754 | -122.467053051482 | (37.7430261153754, -122.467053051482) | 1 | 8 | 4 | 59 | 40 | |||
| 51427 | 65673 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 355 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1990 12:00:00 AM | Permit Number 28593 | 5997947.70792661 | 2098297.78452014 | 37.7414081426615 | -122.449699493918 | (37.7414081426615, -122.449699493918) | 9 | 7 | 4 | 59 | 40 | ||
| 98687 | 218805 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 67 Marne Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5995289.12081 | 2097585.29615 | 37.73929936437 | -122.458840331911 | (37.73929936437, -122.458840331911) | 9 | 7 | 4 | 59 | 40 | |||
| 113933 | 218843 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 661 Rockdale Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5997657.5738 | 2098142.02161 | 37.7409638520942 | -122.450691444481 | (37.7409638520942, -122.450691444481) | 9 | 7 | 4 | 59 | 40 | |||
| 132605 | 218804 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 161 San Rafael Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5991882.49508 | 2095116.63402 | 37.7323246389721 | -122.470439076297 | (37.7323246389721, -122.470439076297) | 9 | 8 | 4 | 59 | 40 | |||
| 139406 | 218842 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 101 Stanford Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997801.41833 | 2096410.61107 | 37.7362180487182 | -122.450069323134 | (37.7362180487182, -122.450069323134) | 9 | 7 | 4 | 59 | 40 | |||
| 18380 | 65586 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1779 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Permit Number 28486 | 6014089.25997 | 2096159.17746 | 37.7364462435881 | -122.393737527685 | (37.7364462435881, -122.393737527685) | 10 | 3 | 8 | 58 | 1 | ||
| 23203 | 6798 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1375 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x9 | 6016915.23611 | 2097187.56543 | 37.7394266247399 | -122.384038431137 | (37.7394266247399, -122.384038431137) | 10 | 3 | 8 | 58 | 1 | |||
| 30016 | 199432 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1400 Newhall St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6014474.33722 | 2095838.07196 | 37.7355859449403 | -122.39238369005 | (37.7355859449403, -122.39238369005) | 10 | 3 | 8 | 58 | 1 | |||
| 31557 | 199435 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6014455.52547 | 2095885.24717 | 37.735714433762 | -122.392452028664 | (37.735714433762, -122.392452028664) | 10 | 3 | 8 | 58 | 1 | |||
| 39941 | 6742 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1300X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 01:53:00 PM | 3 | 3x3 | 6016901.50063 | 2097278.26947 | 37.7396749203573 | -122.384092237585 | (37.7396749203573, -122.384092237585) | 10 | 3 | 8 | 58 | 1 | ||
| 71962 | 199434 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6014431.27107 | 2095902.06527 | 37.7357592658851 | -122.392537062245 | (37.7357592658851, -122.392537062245) | 10 | 3 | 8 | 58 | 1 | |||
| 101216 | 199433 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1400 Newhall St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6014453.55095 | 2095806.16281 | 37.7354971746608 | -122.392453325466 | (37.7354971746608, -122.392453325466) | 10 | 3 | 8 | 58 | 1 | |||
| 118175 | 26002 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6014429.78226 | 2095903.68978 | 37.7357636437757 | -122.392542323281 | (37.7357636437757, -122.392542323281) | 10 | 3 | 8 | 58 | 1 | |||
| 120742 | 26003 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6014451.27252 | 2095887.995 | 37.7357217425631 | -122.39246692502 | (37.7357217425631, -122.39246692502) | 10 | 3 | 8 | 58 | 1 | |||
| 121851 | 61725 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 66 Williams Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/1985 12:00:00 AM | Permit Number 21727 | 6013825.41276045 | 2093670.69143799 | 37.7295987054368 | -122.394475571882 | (37.7295987054368, -122.394475571882) | 10 | 3 | 8 | 58 | 1 | ||
| 129824 | 26001 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6014400.39468 | 2095925.25999 | 37.7358212390678 | -122.392645436853 | (37.7358212390678, -122.392645436853) | 10 | 3 | 8 | 58 | 1 | |||
| 1590 | 130502 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1971 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5999816.57477 | 2121214.69005 | 37.8044388979007 | -122.444884593948 | (37.8044388979007, -122.444884593948) | 13 | 9 | 1 | 57 | 17 | |||
| 5816 | 130501 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1971 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5999805.39025 | 2121212.90425 | 37.8044333562689 | -122.444923170372 | (37.8044333562689, -122.444923170372) | 13 | 9 | 1 | 57 | 17 | |||
| 19308 | 64963 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1701 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1989 12:00:00 AM | Permit Number 25998 | 6004752.02742796 | 2119466.94279483 | 37.7999204646826 | -122.427680422256 | (37.7999204646826, -122.427680422256) | 13 | 9 | 1 | 57 | 17 | ||
| 29430 | 114806 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2811 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6004778.36642477 | 2119194.00734605 | 37.7991725438245 | -122.427569823594 | (37.7991725438245, -122.427569823594) | 13 | 9 | 1 | 57 | 17 | ||||
| 36758 | 61440 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2660 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/1984 12:00:00 AM | 14 | Permit Number 21375 | 6000247.84617 | 2118544.37503 | 37.7971315285518 | -122.443200241996 | (37.7971315285518, -122.443200241996) | 13 | 9 | 1 | 57 | 17 | ||
| 38158 | 101288 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 3355X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001810.5 | 2119614.7 | 37.8001593395999 | -122.437869785341 | (37.8001593395999, -122.437869785341) | 13 | 9 | 1 | 57 | 17 | ||||
| 46698 | 58912 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2308 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/1980 12:00:00 AM | 18 | Permit Number 776948 | 6001885.65083 | 2118771.72016 | 37.7978490112876 | -122.437549333047 | (37.7978490112876, -122.437549333047) | 13 | 9 | 1 | 57 | 17 | ||
| 63143 | 65844 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2 Richardson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1990 12:00:00 AM | Permit Number 28834 | 5999811.44226859 | 2119196.23574668 | 37.798896470812 | -122.444757181443 | (37.798896470812, -122.444757181443) | 13 | 9 | 1 | 57 | 17 | ||
| 79230 | 103152 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2190X Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x9 | 6002428.2 | 2119190 | 37.7990283301562 | -122.435701904836 | (37.7990283301562, -122.435701904836) | 13 | 9 | 1 | 57 | 17 | ||||
| 84851 | 59876 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2195X Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1981 12:00:00 AM | 3x3 | Permit Number 768644 | 6002471.9091323 | 2118692.46196613 | 37.7976647031079 | -122.43551504484 | (37.7976647031079, -122.43551504484) | 13 | 9 | 1 | 57 | 17 | ||
| 92420 | 126617 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3001 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 5999428.93901 | 2119163.44026 | 37.7987845877085 | -122.446078403512 | (37.7987845877085, -122.446078403512) | 13 | 9 | 1 | 57 | 17 | |||
| 95218 | 103153 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2190X Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x9 | 6002428.2 | 2119190 | 37.7990283301562 | -122.435701904836 | (37.7990283301562, -122.435701904836) | 13 | 9 | 1 | 57 | 17 | ||||
| 127353 | 23546 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2805 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005607.92942 | 2120044.70688 | 37.8015552343461 | -122.424759800825 | (37.8015552343461, -122.424759800825) | 13 | 9 | 1 | 57 | 17 | |||
| 140524 | 126616 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2660 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6000233.00854 | 2118542.38093 | 37.7971252072193 | -122.443251440404 | (37.7971252072193, -122.443251440404) | 13 | 9 | 1 | 57 | 17 | |||
| 143284 | 32039 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3653 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1995 12:00:00 AM | Permit Number 35422 | 6003092.33534727 | 2120827.43015376 | 37.8035619867255 | -122.433520856524 | (37.8035619867255, -122.433520856524) | 13 | 9 | 1 | 57 | 17 | |||
| 143730 | 114807 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2811 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6004778.36642477 | 2119194.00734605 | 37.7991725438245 | -122.427569823594 | (37.7991725438245, -122.427569823594) | 13 | 9 | 1 | 57 | 17 | ||||
| 150139 | 31210 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2736 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1995 12:00:00 AM | Permit Number 34902 | 6001624.16755345 | 2117801.03750222 | 37.7951689006516 | -122.438384556872 | (37.7951689006516, -122.438384556872) | 13 | 9 | 1 | 57 | 27 | |||
| 171200 | 93707 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1864 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53296 | 6004115 | 2118383 | 37.7969081825869 | -122.429807420143 | (37.7969081825869, -122.429807420143) | 13 | 9 | 1 | 57 | 17 | |||
| 181653 | 103151 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2190X Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x9 | 6002428.2 | 2119190 | 37.7990283301562 | -122.435701904836 | (37.7990283301562, -122.435701904836) | 13 | 9 | 1 | 57 | 17 | ||||
| 182596 | 64939 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1904 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/1989 12:00:00 AM | 14 | 4x9 | Permit Number 25968 | 6003770.59823 | 2119034.75591 | 37.798678227572 | -122.431045672521 | (37.798678227572, -122.431045672521) | 13 | 9 | 1 | 57 | 17 | |
| 5392 | 60144 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1614 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19674 | 5990908.81036863 | 2104400.55481137 | 37.7577595366377 | -122.474482571431 | (37.7577595366377, -122.474482571431) | 1 | 8 | 4 | 56 | 12 | ||
| 5550 | 207625 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1223 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5995447.2053 | 2107231.58705 | 37.7657947273793 | -122.458992007973 | (37.7657947273793, -122.458992007973) | 15 | 5 | 11 | 56 | 12 | |||
| 26889 | 54520 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 836 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | Permit Number 11498 | 5993201.36132572 | 2106658.05231245 | 37.7640905954535 | -122.466718145476 | (37.7640905954535, -122.466718145476) | 11 | 8 | 11 | 56 | 12 | |||
| 27917 | 101249 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 734 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993518 | 2106670 | 37.764141669108 | -122.465623861668 | (37.764141669108, -122.465623861668) | 11 | 8 | 11 | 56 | 12 | ||||
| 37941 | 184315 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1557 39th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5984032.5928 | 2104430.6415 | 37.7574413473895 | -122.498265228241 | (37.7574413473895, -122.498265228241) | 1 | 8 | 3 | 56 | 35 | |||
| 43482 | 101285 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1236 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 11316 | 5993350.8 | 2107040.7 | 37.7651498684815 | -122.466229094974 | (37.7651498684815, -122.466229094974) | 11 | 8 | 11 | 56 | 12 | |||
| 54947 | 63166 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1534 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1986 12:00:00 AM | Permit Number 23703 | 5992780.43210356 | 2105015.68842996 | 37.7595567946867 | -122.468054529997 | (37.7595567946867, -122.468054529997) | 1 | 8 | 4 | 56 | 12 | ||
| 55197 | 60152 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1790 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19683 | 5990948.80079989 | 2103226.18449464 | 37.7545373426794 | -122.474258577533 | (37.7545373426794, -122.474258577533) | 1 | 8 | 4 | 56 | 12 | ||
| 57590 | 218841 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1522 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5994017.40797 | 2105128.44374 | 37.7599377495509 | -122.463784669644 | (37.7599377495509, -122.463784669644) | 1 | 5 | 4 | 56 | 12 | |||
| 68365 | 98237 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1299X 09th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 32025 | 5993314 | 2106663 | 37.7641106803471 | -122.466328924005 | (37.7641106803471, -122.466328924005) | 11 | 8 | 11 | 56 | 12 | ||||
| 77132 | 184317 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1557 39th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5984033.1876 | 2104377.9194 | 37.7572966221146 | -122.498259277429 | (37.7572966221146, -122.498259277429) | 1 | 8 | 3 | 56 | 35 | |||
| 77511 | 54514 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1221 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1983 12:00:00 AM | Permit Number 20683 | 5995443.00414725 | 2107246.09430383 | 37.7658343190377 | -122.459007589279 | (37.7658343190377, -122.459007589279) | 15 | 5 | 11 | 56 | 12 | ||
| 77928 | 55379 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1236 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/1972 12:00:00 AM | Permit Number 11316 | 5993330.37884563 | 2107053.53607455 | 37.7651839347095 | -122.466300659155 | (37.7651839347095, -122.466300659155) | 11 | 8 | 11 | 56 | 12 | |||
| 83507 | 98238 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1299X 09th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 32025 | 5993314 | 2106663 | 37.7641106803471 | -122.466328924005 | (37.7641106803471, -122.466328924005) | 11 | 8 | 11 | 56 | 12 | ||||
| 122820 | 65917 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1322 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | Permit Number 28932 | 5994588.71634117 | 2106515.79856518 | 37.7637799716089 | -122.461909408356 | (37.7637799716089, -122.461909408356) | 15 | 5 | 11 | 56 | 12 | ||
| 141932 | 41283 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3948 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2000 12:00:00 AM | 0 | Permit Number 41961 | 5981803.95386186 | 2102184.90266006 | 37.7511442517842 | -122.505806132064 | (37.7511442517842, -122.505806132064) | 1 | 8 | 3 | 56 | 35 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );