trees
969 rows where qSpecies_id = 97 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32878 | 12244 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 401X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005028.53136 | 2110211.81183 | 37.7745238232573 | -122.426064391571 | (37.7745238232573, -122.426064391571) | 7 | 9 | 11 | 28852 | 10 | |||
33097 | 176407 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 65 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998589.29961 | 2087923.49641 | 37.7129594608753 | -122.446734823157 | (37.7129594608753, -122.446734823157) | 9 | 7 | 6 | 28861 | 25 | |||
33103 | 224636 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 161 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007205.3997 | 2098201.35341 | 37.7416686669758 | -122.417682698402 | (37.7416686669758, -122.417682698402) | 2 | 7 | 7 | 28859 | 2 | |||
33181 | 224693 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 281 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006755.71735 | 2102172.37571 | 37.7525468808523 | -122.41951921745 | (37.7525468808523, -122.41951921745) | 2 | 4 | 7 | 28859 | 19 | |||
33250 | 224563 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3121 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008575.93906 | 2105040.68247 | 37.7605249582808 | -122.413427391562 | (37.7605249582808, -122.413427391562) | 2 | 4 | 7 | 28859 | 19 | |||
34847 | 173694 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 201X Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011772 | 2114653 | 37.7870971135768 | -122.403049742128 | (37.7870971135768, -122.403049742128) | 12 | 2 | 9 | 28853 | 6 | ||||
35509 | 224601 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3328 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6006122.42737 | 2103775.96782 | 37.756914282788 | -122.421823142019 | (37.756914282788, -122.421823142019) | 2 | 4 | 5 | 28859 | 19 | |||
36000 | 104437 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 534 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005464 | 2111103 | 37.7769954116482 | -122.424621427703 | (37.7769954116482, -122.424621427703) | 7 | 9 | 11 | 28852 | 10 | |||||
36047 | 69485 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 560 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/1994 12:00:00 AM | Permit Number 33606 | 6008946.01217425 | 2105621.19939594 | 37.7621396967865 | -122.412188502645 | (37.7621396967865, -122.412188502645) | 8 | 4 | 7 | 28859 | 19 | ||
36191 | 251014 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3828 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995959.01851 | 2115881.76769 | 37.7895752475348 | -122.457847777179 | (37.7895752475348, -122.457847777179) | 11 | 6 | 1 | 54 | 31 | |||
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 | |||
36271 | 126620 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1430 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6007903.30397 | 2116551.24821 | 37.7920924400618 | -122.416569132658 | (37.7920924400618, -122.416569132658) | 5 | 1 | 10 | 28858 | 21 | |||
36309 | 577 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3024 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008801.63126 | 2102168.54838 | 37.7526513982496 | -122.412443801263 | (37.7526513982496, -122.412443801263) | 2 | 4 | 7 | 28859 | 19 | |||
36413 | 33765 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1580 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | 8 | 2 | 9 | 28853 | 19 | |||
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 | ||
37053 | 176425 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3338 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011982.06755 | 2090001.33634 | 37.7194207606357 | -122.400590586484 | (37.7194207606357, -122.400590586484) | 10 | 7 | 8 | 309 | 28 | |||
37346 | 250802 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 283 31st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 5986182.86321 | 2114039.35976 | 37.7839500331106 | -122.491536104007 | (37.7839500331106, -122.491536104007) | 11 | 6 | 1 | 55 | 33 | |||
37377 | 176427 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 383 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6010742.02473 | 2089174.64706 | 37.7170816042145 | -122.404818807562 | (37.7170816042145, -122.404818807562) | 9 | 7 | 8 | 309 | 39 | |||
38124 | 552 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2904 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009418.497 | 2102204.07854 | 37.7527835545272 | -122.410313070807 | (37.7527835545272, -122.410313070807) | 2 | 4 | 7 | 28859 | 19 | |||
38338 | 62653 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 250 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1986 12:00:00 AM | Permit Number 22975 | 6003520.74083492 | 2109179.36788903 | 37.7716036530228 | -122.431206419247 | (37.7716036530228, -122.431206419247) | 15 | 9 | 11 | 29492 | 10 | ||
39537 | 61715 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 281 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1984 12:00:00 AM | Permit Number 21715 | 6004926.94134289 | 2108179.4823523 | 37.7689377963385 | -122.42627108706 | (37.7689377963385, -122.42627108706) | 8 | 4 | 5 | 28853 | 19 | ||
39589 | 224649 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 24 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6007194.88444 | 2099407.51056 | 37.7449799131997 | -122.41780453317 | (37.7449799131997, -122.41780453317) | 2 | 7 | 7 | 28859 | 2 | |||
39650 | 224603 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3360 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6005941.90978 | 2103767.20067 | 37.7568800285 | -122.42244681736 | (37.7568800285, -122.42244681736) | 2 | 4 | 5 | 28859 | 19 | |||
39862 | 7496 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2696 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008261.67558 | 2102751.78327 | 37.754222512966 | -122.414352332587 | (37.754222512966, -122.414352332587) | 2 | 4 | 7 | 28859 | 19 | |||
40283 | 30534 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1020 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.77681277294 | -122.404779881684 | (37.77681277294, -122.404779881684) | 14 | 2 | 9 | 28853 | 34 | |||
40421 | 61705 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 57 Rosemont Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1984 12:00:00 AM | Permit Number 21704 | 6005150.34156307 | 2107947.67774505 | 37.7683139415326 | -122.42548186082 | (37.7683139415326, -122.42548186082) | 8 | 4 | 5 | 28853 | 19 | ||
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 | |||
41084 | 48790 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/2006 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | ||
41504 | 33816 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1201 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1997 12:00:00 AM | Permit Number 37831 | 6008598.80477101 | 2116262.85239853 | 37.7913396656633 | -122.414142270961 | (37.7913396656633, -122.414142270961) | 5 | 1 | 10 | 28858 | 21 | |||
41908 | 35231 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 402 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1998 12:00:00 AM | Permit Number 38724 | 6003567.92997574 | 2105934.61117361 | 37.7626970125211 | -122.430811591359 | (37.7626970125211, -122.430811591359) | 15 | 4 | 5 | 28862 | 3 | |||
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 | ||
42368 | 255609 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 355X San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006938 | 2104061 | 37.7577428748963 | -122.419022796788 | (37.7577428748963, -122.419022796788) | 2 | 4 | 7 | 28859 | 19 | ||||
42609 | 67152 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 412 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1992 12:00:00 AM | Permit Number 30584 | 6009956.04429273 | 2098629.91177988 | 37.7429997970033 | -122.408202066775 | (37.7429997970033, -122.408202066775) | 10 | 7 | 7 | 28859 | 2 | ||
42763 | 224607 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3540 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6005920.82892 | 2102594.51157 | 37.753658906948 | -122.42243640053 | (37.753658906948, -122.42243640053) | 2 | 4 | 5 | 28859 | 19 | |||
42798 | 224620 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1316 Clayton St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 5999063.56077 | 2105040.06353 | 37.759984571857 | -122.446326183806 | (37.759984571857, -122.446326183806) | 15 | 5 | 5 | 28862 | 3 | |||
42809 | 33580 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 161 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37688 | 6007154.09999929 | 2098074.89925627 | 37.7413185651373 | -122.417851114389 | (37.7413185651373, -122.417851114389) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
44712 | 30926 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 230 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 13 | Permit Number 34739 | 5996065.71046 | 2091231.30039 | 37.7218974306099 | -122.455696079012 | (37.7218974306099, -122.455696079012) | 9 | 8 | 4 | 28861 | 24 | |
44755 | 124423 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 207 Cherry St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 5996107.97218 | 2115471.34233 | 37.78845688642 | -122.457302712744 | (37.78845688642, -122.457302712744) | 11 | 6 | 1 | 54 | 31 | |||
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 | ||
45268 | 59350 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 97 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/1987 12:00:00 AM | Permit Number 23892 | 6007961.12301785 | 2099994.21526918 | 37.7466339645312 | -122.415196534166 | (37.7466339645312, -122.415196534166) | 2 | 7 | 7 | 28859 | 2 | ||
45475 | 224673 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 610 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007868.35883 | 2104304.97763 | 37.7584651276847 | -122.415822498411 | (37.7584651276847, -122.415822498411) | 2 | 4 | 7 | 28859 | 19 | |||
46673 | 63412 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 832 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1987 12:00:00 AM | Permit Number 23995 | 6007544.46590294 | 2095494.67209225 | 37.7342557904854 | -122.416318652779 | (37.7342557904854, -122.416318652779) | 2 | 7 | 7 | 28859 | 2 | ||
46674 | 111609 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 301x Ward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 15x3 | 6011168.56615 | 2089615.14952 | 37.7183149668287 | -122.403375421742 | (37.7183149668287, -122.403375421742) | 10 | 7 | 8 | 309 | 39 | |||
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 | ||
46703 | 633 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3182 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6007808.47554 | 2102110.59584 | 37.7524364890666 | -122.415874214834 | (37.7524364890666, -122.415874214834) | 2 | 4 | 7 | 28859 | 19 | |||
46822 | 34158 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
46860 | 126624 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 801x Greenwich St | 1 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6009066.28691 | 2120109.01558 | 37.8019265293585 | -122.412796822924 | (37.8019265293585, -122.412796822924) | 3 | 1 | 10 | 308 | 4 | |||
47140 | 218809 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 118 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996535.53946 | 2090678.52967 | 37.720406603762 | -122.45403210661 | (37.720406603762, -122.45403210661) | 9 | 8 | 6 | 28861 | 24 | |||
47723 | 224642 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 235 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6006381.67631 | 2098450.75503 | 37.742307080422 | -122.420548562565 | (37.742307080422, -122.420548562565) | 2 | 7 | 7 | 28859 | 2 | |||
47834 | 106690 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 98X CHATTANOOGA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 4x4 | 6004701 | 2103385 | 37.7557605147563 | -122.426711131232 | (37.7557605147563, -122.426711131232) | 2 | 4 | 5 | 28862 | 22 | |||
47963 | 226470 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3101 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008736.33721 | 2105092.98384 | 37.76067757053 | -122.412876343665 | (37.76067757053, -122.412876343665) | 2 | 4 | 7 | 28859 | 19 | |||
48982 | 176417 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 825 Lisbon St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6001125.80716 | 2088973.54213 | 37.7159872246076 | -122.438043004189 | (37.7159872246076, -122.438043004189) | 9 | 7 | 6 | 28861 | 5 | |||
49673 | 66438 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 650X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1991 12:00:00 AM | Permit Number 29582 | 6003603.61647971 | 2110556.18401653 | 37.7753887478808 | -122.431018029936 | (37.7753887478808, -122.431018029936) | 7 | 9 | 11 | 29492 | 10 | ||
50215 | 176416 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 860 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000990.84724 | 2088839.6326 | 37.715611862882 | -122.438499899353 | (37.715611862882, -122.438499899353) | 9 | 7 | 6 | 28861 | 5 | |||
50241 | 61716 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 271 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1984 12:00:00 AM | Permit Number 21716 | 6004986.55656035 | 2108182.89626107 | 37.7689505396343 | -122.426065124893 | (37.7689505396343, -122.426065124893) | 8 | 4 | 5 | 28853 | 19 | ||
50729 | 67095 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 432 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30500 | 6009952.08043631 | 2098577.67814271 | 37.7428561528472 | -122.408212089588 | (37.7428561528472, -122.408212089588) | 10 | 7 | 7 | 28859 | 2 | ||
50861 | 60838 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 261 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20611 | 6004794.55991917 | 2102160.27475876 | 37.75240299462 | -122.426300377591 | (37.75240299462, -122.426300377591) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
51538 | 66220 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1 Dolores Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1990 12:00:00 AM | Permit Number 29312 | 6005304.82019082 | 2105877.54249684 | 37.7626385702507 | -122.424800241819 | (37.7626385702507, -122.424800241819) | 8 | 4 | 5 | 28859 | 19 | ||
52542 | 224684 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3513 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006347.14535 | 2101407.65794 | 37.7504241193009 | -122.420877843938 | (37.7504241193009, -122.420877843938) | 2 | 4 | 5 | 28859 | 19 | |||
52676 | 224579 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2577 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008913.82756 | 2103471.3398 | 37.7562348656635 | -122.412147871222 | (37.7562348656635, -122.412147871222) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
53369 | 67032 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 255 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012868.03417039 | 2116855.7141363 | 37.7932063935721 | -122.399412377848 | (37.7932063935721, -122.399412377848) | 4 | 1 | 10 | 28860 | 6 | |||
54116 | 24446 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1156 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6006345.52984 | 2102866.64807 | 37.7544300800889 | -122.420987008139 | (37.7544300800889, -122.420987008139) | 2 | 4 | 5 | 28859 | 19 | |||
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 | ||
55089 | 600 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3078 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6008460.582 | 2102146.28241 | 37.7525711157729 | -122.413621638824 | (37.7525711157729, -122.413621638824) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||
55241 | 5358 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 230 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6004797.67228 | 2107012.30465 | 37.7657256990156 | -122.426635095043 | (37.7657256990156, -122.426635095043) | 8 | 4 | 5 | 28862 | 3 | |||
55334 | 224658 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 127 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007231.85422 | 2100130.75523 | 37.7469678609981 | -122.41772795229 | (37.7469678609981, -122.41772795229) | 2 | 7 | 7 | 28859 | 2 | |||
56103 | 224554 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3363 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007798.32865 | 2104414.86293 | 37.7587629102964 | -122.416072476661 | (37.7587629102964, -122.416072476661) | 2 | 4 | 7 | 28859 | 19 | |||
56192 | 61710 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1975 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1984 12:00:00 AM | Permit Number 21709 | 6004910.69371619 | 2108330.79575039 | 37.7693523480889 | -122.426338061309 | (37.7693523480889, -122.426338061309) | 8 | 4 | 5 | 28862 | 19 | ||
56378 | 34142 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 400 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1997 12:00:00 AM | Permit Number 37990 | 6008524.65557539 | 2106230.12436926 | 37.7637880127631 | -122.413688890617 | (37.7637880127631, -122.413688890617) | 8 | 4 | 7 | 28859 | 19 | ||
57362 | 65894 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 649 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/1990 12:00:00 AM | Permit Number 28901 | 6009912.39060761 | 2119145.15114701 | 37.7993274494867 | -122.409800817555 | (37.7993274494867, -122.409800817555) | 3 | 1 | 10 | 308 | 4 | ||
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 | |||
58481 | 65402 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 760 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1989 12:00:00 AM | 12 | 3x3 | Permit Number 28251 | 6008077 | 2114493 | 37.7864507606031 | -122.415822330961 | (37.7864507606031, -122.415822330961) | 13 | 1 | 9 | 28858 | 36 |
58522 | 98530 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 701X 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991613.7 | 2110635.6 | 37.7749201175533 | -122.472499350726 | (37.7749201175533, -122.472499350726) | 11 | 6 | 2 | 54 | 26 | ||||
58779 | 63899 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 719 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1987 12:00:00 AM | Permit Number 24609 | 6002042.34774334 | 2110925.77664223 | 37.7763149662139 | -122.436445273797 | (37.7763149662139, -122.436445273797) | 15 | 5 | 11 | 29492 | 10 | ||
59124 | 226494 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2300 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008770.52865 | 2104997.08999 | 37.7604161870861 | -122.412751310945 | (37.7604161870861, -122.412751310945) | 2 | 4 | 7 | 28859 | 19 | |||
59240 | 60839 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 271 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20613 | 6004797.43728628 | 2102104.7326602 | 37.7522506515925 | -122.426286473113 | (37.7522506515925, -122.426286473113) | 2 | 4 | 5 | 28862 | 22 | ||
59959 | 176428 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 250 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009763.04467 | 2087916.93122 | 37.7135734055712 | -122.408114037746 | (37.7135734055712, -122.408114037746) | 9 | 7 | 8 | 309 | 39 | |||
59992 | 224513 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1115 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008070.04378 | 2101397.41005 | 37.7504929435022 | -122.41491919326 | (37.7504929435022, -122.41491919326) | 2 | 4 | 7 | 28859 | 19 | |||
60273 | 60549 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 523 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20159 | 5985000.44766821 | 2112307.598992 | 37.7791259492381 | -122.495498998876 | (37.7791259492381, -122.495498998876) | 11 | 6 | 2 | 55 | 26 | ||
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 | ||
60878 | 224499 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 35 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6007169.2602 | 2099278.27912 | 37.744623630583 | -122.417883978366 | (37.744623630583, -122.417883978366) | 2 | 7 | 7 | 28859 | 2 | |||
60993 | 61785 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1495 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1987 12:00:00 AM | Permit Number 24636 | 6012051.50334521 | 2101403.29784414 | 37.7507320294913 | -122.401151335946 | (37.7507320294913, -122.401151335946) | 10 | 3 | 8 | 28856 | 29 | ||
61058 | 166227 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3200 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6007587.23887 | 2102689.09416 | 37.7540124736145 | -122.416680268187 | (37.7540124736145, -122.416680268187) | 2 | 4 | 7 | 28859 | 19 | |||
61066 | 224608 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3552 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005826.64329 | 2102589.60435 | 37.7536401192198 | -122.422761767144 | (37.7536401192198, -122.422761767144) | 2 | 4 | 5 | 28859 | 19 | |||
61132 | 38252 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1556 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | 24 | 4x6 | Permit Number 40362 | 6007050.76125355 | 2107358.39166569 | 37.7668030933038 | -122.418866676369 | (37.7668030933038, -122.418866676369) | 8 | 4 | 7 | 28853 | 19 | |
61290 | 576 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3008 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008852.23919 | 2102169.31321 | 37.7526563382221 | -122.412268843556 | (37.7526563382221, -122.412268843556) | 2 | 4 | 7 | 28859 | 19 | |||
62313 | 61708 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 580 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1984 12:00:00 AM | Permit Number 21707 | 6004928.75046121 | 2107826.22237424 | 37.767967931643 | -122.426239675726 | (37.767967931643, -122.426239675726) | 8 | 4 | 5 | 28853 | 19 | ||
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 | ||
63531 | 99175 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 300x BEACH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008712 | 2122248 | 37.8077797512209 | -122.414174245084 | (37.8077797512209, -122.414174245084) | 3 | 1 | 10 | 308 | 23 | ||||
63739 | 60831 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 205 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20604 | 6004778.44666437 | 2102471.31049199 | 37.7532561154195 | -122.426378243722 | (37.7532561154195, -122.426378243722) | 2 | 4 | 5 | 28862 | 22 | ||
64691 | 60840 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 315 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20614 | 6004809.28697134 | 2101883.59513704 | 37.7516441291888 | -122.426229752639 | (37.7516441291888, -122.426229752639) | 2 | 4 | 5 | 28862 | 22 | ||
64863 | 60554 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 562 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20164 | 5985061.1383554 | 2112041.58145553 | 37.7783990952425 | -122.495269425078 | (37.7783990952425, -122.495269425078) | 11 | 6 | 2 | 55 | 26 | ||
65040 | 622 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3150 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 6007969.89189 | 2102118.08704 | 37.7524661316063 | -122.415316538925 | (37.7524661316063, -122.415316538925) | 2 | 4 | 7 | 28859 | 19 | |||
65274 | 224595 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3139 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005929.78445 | 2106647.58051 | 37.7647881917533 | -122.422693436658 | (37.7647881917533, -122.422693436658) | 8 | 4 | 5 | 28859 | 19 | |||
65463 | 224530 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3055 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 3ft | 6008605.15504 | 2102119.10209 | 37.752504601916 | -122.413119756879 | (37.752504601916, -122.413119756879) | 2 | 4 | 7 | 28859 | 19 | |||
65684 | 65243 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1086 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28037 | 6009165.76758609 | 2102839.33295033 | 37.7545136503205 | -122.411231929366 | (37.7545136503205, -122.411231929366) | 2 | 4 | 7 | 28859 | 19 |
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) );