trees
969 rows where qSpecies_id = 97 sorted by XCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13355 | 62304 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2504 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1985 12:00:00 AM | Permit Number 22442 | 5997225.79467532 | 2110840.29768365 | 37.7758053966105 | -122.453100806219 | (37.7758053966105, -122.453100806219) | 15 | 6 | 2 | 54 | 16 | ||
| 29118 | 61140 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2132 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/01/1983 12:00:00 AM | Permit Number 20992 | 5997609.15376905 | 2110265.51143343 | 37.7742491458885 | -122.451733203729 | (37.7742491458885, -122.451733203729) | 15 | 5 | 2 | 29492 | 16 | ||
| 114874 | 61139 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2128 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/01/1983 12:00:00 AM | Permit Number 20991 | 5997627.50212199 | 2110268.03572246 | 37.7742571277486 | -122.451669915896 | (37.7742571277486, -122.451669915896) | 15 | 5 | 2 | 29492 | 16 | ||
| 188441 | 224628 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1053 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5997656.24362 | 2106853.17472 | 37.7648824406996 | -122.45132415711 | (37.7648824406996, -122.45132415711) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 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 | |||
| 140738 | 244051 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 401 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997898.1905 | 2109198.4158 | 37.7713357252186 | -122.450656427551 | (37.7713357252186, -122.450656427551) | 15 | 5 | 11 | 29492 | 9 | |||
| 78159 | 244052 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 401 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5997900.6668 | 2109181.4943 | 37.771289404865 | -122.450646641766 | (37.771289404865, -122.450646641766) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | ||
| 129082 | 126622 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3340 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5998235.51312 | 2116198.50625 | 37.7905754501486 | -122.449994218979 | (37.7905754501486, -122.449994218979) | 13 | 6 | 1 | 54 | 31 | |||
| 98693 | 218808 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 379 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998237.66884 | 2094066.68072 | 37.7298071263007 | -122.448392288972 | (37.7298071263007, -122.448392288972) | 9 | 7 | 4 | 28861 | 40 | ||||
| 5619 | 60093 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3340 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/1982 12:00:00 AM | 15 | Permit Number 19594 | 5998249.44913 | 2116202.11644 | 37.7905861601801 | -122.449946261722 | (37.7905861601801, -122.449946261722) | 13 | 6 | 1 | 54 | 31 | |
| 12949 | 59480 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3326 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1980 12:00:00 AM | 13 | Permit Number 18850 | 5998315.87391 | 2116208.53382 | 37.7906075811119 | -122.449716899529 | (37.7906075811119, -122.449716899529) | 13 | 6 | 1 | 54 | 31 | ||
| 70716 | 224492 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 60 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5998346.42262 | 2106894.64873 | 37.7650358128629 | -122.448940002185 | (37.7650358128629, -122.448940002185) | 15 | 5 | 11 | 29492 | 9 | |||
| 116135 | 224491 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 60 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5998359.17902 | 2106895.28933 | 37.7650383013108 | -122.4488959273 | (37.7650383013108, -122.4488959273) | 15 | 5 | 11 | 29492 | 9 | |||
| 129070 | 224489 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 24 Alma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5998519.39636 | 2106289.88206 | 37.7633851666273 | -122.448298178534 | (37.7633851666273, -122.448298178534) | 15 | 5 | 11 | 29492 | 9 | |||
| 145528 | 224488 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 24 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5998533.31147 | 2106291.41144 | 37.7633901614449 | -122.448250161025 | (37.7633901614449, -122.448250161025) | 15 | 5 | 11 | 29492 | 9 | |||
| 59306 | 176406 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 75 Dichiera Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 2ft | 5998546.73235 | 2087959.10708 | 37.7130548079177 | -122.446884509935 | (37.7130548079177, -122.446884509935) | 9 | 7 | 6 | 28861 | 25 | |||
| 115754 | 176405 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 75 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 5998552.29871 | 2087983.35456 | 37.7131217039812 | -122.446867014517 | (37.7131217039812, -122.446867014517) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 183843 | 176408 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 55 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998608.92575 | 2087907.12594 | 37.7129156324143 | -122.446665811891 | (37.7129156324143, -122.446665811891) | 9 | 7 | 6 | 28861 | 25 | |||
| 144874 | 176409 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 45 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5998625.6999 | 2087888.85423 | 37.7128664206305 | -122.44660652137 | (37.7128664206305, -122.44660652137) | 9 | 7 | 6 | 28861 | 25 | |||
| 175405 | 176404 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 332 Ellington Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5998751.95541 | 2087834.14028 | 37.712723399629 | -122.446166209719 | (37.712723399629, -122.446166209719) | 9 | 7 | 6 | 28861 | 25 | |||
| 41384 | 176403 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 332 Ellington Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5998770.03746 | 2087851.68696 | 37.7127726114513 | -122.446104973962 | (37.7127726114513, -122.446104973962) | 9 | 7 | 6 | 28861 | 25 | |||
| 108720 | 224490 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 4630 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5998778.21735 | 2105711.32788 | 37.7618113953113 | -122.447361360161 | (37.7618113953113, -122.447361360161) | 15 | 5 | 11 | 29492 | 9 | |||
| 124277 | 176402 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 332 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5998803.89987 | 2087884.30754 | 37.7128641138726 | -122.445990279822 | (37.7128641138726, -122.445990279822) | 9 | 7 | 6 | 28861 | 25 | |||
| 192915 | 66937 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2350 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/1992 12:00:00 AM | Permit Number 30262 | 5998853.41639727 | 2111835.46191539 | 37.7786310079222 | -122.447542123222 | (37.7786310079222, -122.447542123222) | 15 | 6 | 2 | 54 | 16 | ||
| 147021 | 126623 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3200 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5998899.76803 | 2116292.09263 | 37.7908703998933 | -122.447702685234 | (37.7908703998933, -122.447702685234) | 13 | 6 | 1 | 54 | 31 | |||
| 181277 | 68371 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1233 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32193 | 5998967.61980979 | 2105592.97843293 | 37.7614972584923 | -122.446697779287 | (37.7614972584923, -122.446697779287) | 15 | 5 | 11 | 29492 | 12 | ||
| 55915 | 224624 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1323 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5999021.66534 | 2105005.43313 | 37.7598870925388 | -122.446468587874 | (37.7598870925388, -122.446468587874) | 15 | 5 | 5 | 28862 | 12 | |||
| 175614 | 224623 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1323 Clayton St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 5999023.60773 | 2105026.39376 | 37.75994475616 | -122.446463378096 | (37.75994475616, -122.446463378096) | 15 | 5 | 5 | 28862 | 12 | |||
| 178967 | 224622 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1323 Clayton St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 5999026.56459 | 2105047.83376 | 37.7600037939542 | -122.446454694247 | (37.7600037939542, -122.446454694247) | 15 | 5 | 5 | 28862 | 12 | |||
| 17586 | 224621 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1321 Clayton St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 5999027.25079 | 2105080.82131 | 37.7600944087555 | -122.446454694245 | (37.7600944087555, -122.446454694245) | 15 | 5 | 5 | 28862 | 12 | |||
| 189333 | 224619 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1324 Clayton St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 5999058.14954 | 2104997.17372 | 37.7598664980489 | -122.446341813123 | (37.7598664980489, -122.446341813123) | 15 | 5 | 5 | 28862 | 3 | |||
| 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 | |||
| 181231 | 57942 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 15 Byron Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776219 | 5999289.47216 | 2086646.12526 | 37.7094920599881 | -122.444223069735 | (37.7094920599881, -122.444223069735) | 9 | 7 | 6 | 28861 | 5 | |
| 173183 | 57946 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 10 Byron Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | 9 | Permit Number 16905 | 5999382.31979 | 2086721.86457 | 37.7097053198058 | -122.443907611844 | (37.7097053198058, -122.443907611844) | 9 | 7 | 6 | 28861 | 5 | ||
| 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 | |||
| 181335 | 224625 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50 Piedmont St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 5ft | 5999457.54578 | 2107020.99028 | 37.7654461969099 | -122.445105999866 | (37.7654461969099, -122.445105999866) | 15 | 5 | 5 | 29492 | 9 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 86121 | 224493 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 232 Upper Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5999538.9593 | 2106236.29263 | 37.7632962596403 | -122.444768001354 | (37.7632962596403, -122.444768001354) | 15 | 5 | 5 | 29492 | 9 | |||
| 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 | ||
| 78380 | 62435 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 297 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 22596 | 5999684.09914601 | 2105294.09451438 | 37.7607174991734 | -122.444198303008 | (37.7607174991734, -122.444198303008) | 15 | 5 | 5 | 28862 | 3 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 165235 | 224627 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 601 Buena Vista Ave West | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5999834.58358 | 2107589.10397 | 37.7670276079639 | -122.443842736578 | (37.7670276079639, -122.443842736578) | 15 | 5 | 5 | 29492 | 9 | |||
| 182226 | 224626 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 601 Buena Vista Ave West | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5999843.00884 | 2107568.58853 | 37.7669717582745 | -122.443812120926 | (37.7669717582745, -122.443812120926) | 15 | 5 | 5 | 29492 | 9 | |||
| 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 | |||
| 161649 | 62442 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3090 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 22605 | 5999929.32075843 | 2105305.0040382 | 37.7607614409418 | -122.443350977814 | (37.7607614409418, -122.443350977814) | 15 | 5 | 5 | 28862 | 3 | ||
| 128171 | 62436 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 227 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | 14 | 3x3 | Permit Number 772864 | 5999948.2266718 | 2105562.60505464 | 37.7614698277306 | -122.443304093705 | (37.7614698277306, -122.443304093705) | 15 | 5 | 5 | 28862 | 3 |
| 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 | |||
| 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 | ||
| 18680 | 262301 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 2117 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000330 | 2116040 | 37.7902598573453 | -122.44273605224 | (37.7902598573453, -122.44273605224) | 13 | 6 | 1 | 29490 | 27 | ||||
| 139792 | 98913 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2088 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | Permit No. 49312 | 6000424 | 2115788 | 37.7895732892814 | -122.442392720884 | (37.7895732892814, -122.442392720884) | 13 | 6 | 1 | 29490 | 27 | |||
| 74245 | 107997 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2X Clover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | 6000451.13785 | 2105044.8413 | 37.760076841062 | -122.441527580895 | (37.760076841062, -122.441527580895) | 2 | 4 | 5 | 28862 | 3 | ||||
| 74072 | 25396 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 945 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3X3 | 6000465.25163 | 2089064.76788 | 37.7162001220051 | -122.440332727576 | (37.7162001220051, -122.440332727576) | 9 | 7 | 6 | 28861 | 5 | |||
| 91506 | 176412 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2 Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6000489.46107 | 2089401.47314 | 37.7171260172357 | -122.440273180786 | (37.7171260172357, -122.440273180786) | 9 | 7 | 6 | 28861 | 5 | |||
| 16046 | 99287 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2839 Pacific Ave | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6000564.2 | 2116779 | 37.7923023065947 | -122.44197880494 | (37.7923023065947, -122.44197880494) | 13 | 6 | 1 | 29490 | 27 | |||||
| 30326 | 99286 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2839 Pacific Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6000564.2 | 2116779 | 37.7923023065947 | -122.44197880494 | (37.7923023065947, -122.44197880494) | 13 | 6 | 1 | 29490 | 27 | |||||
| 79322 | 25364 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 994 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6000636.2417 | 2088870.05563 | 37.7156752201082 | -122.43972775363 | (37.7156752201082, -122.43972775363) | 9 | 7 | 6 | 28861 | 5 | |||
| 47706 | 176411 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 60 Onondaga Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000874.43024 | 2091115.97701 | 37.7218555689538 | -122.439065336396 | (37.7218555689538, -122.439065336396) | 9 | 7 | 6 | 28861 | 25 | |||
| 137498 | 62505 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 800 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/1986 12:00:00 AM | 15 | Permit Number 22680 | 6000887.29767 | 2089194.58306 | 37.7165805865148 | -122.438883234479 | (37.7165805865148, -122.438883234479) | 9 | 7 | 6 | 28861 | 5 | ||
| 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 | |||
| 122852 | 58069 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 4525 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1991 12:00:00 AM | Permit Number 30131 | 6000914.77254872 | 2105195.89592401 | 37.7605180033322 | -122.439934925187 | (37.7605180033322, -122.439934925187) | 2 | 4 | 5 | 28862 | 3 | ||
| 120959 | 176410 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 60 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000924.60134 | 2091091.49706 | 37.7217912071684 | -122.438890154751 | (37.7217912071684, -122.438890154751) | 9 | 7 | 6 | 28861 | 25 | |||
| 93600 | 37390 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 95 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 15 | Permit Number 41125 | 6000958.3691 | 2088020.28702 | 37.7133602752401 | -122.438553486373 | (37.7133602752401, -122.438553486373) | 9 | 7 | 6 | 28861 | 5 | |
| 115568 | 62139 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 394 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | Permit Number 22347 | 6000980.72200275 | 2092487.56875551 | 37.7256276955072 | -122.438796151694 | (37.7256276955072, -122.438796151694) | 9 | 7 | 6 | 28861 | 25 | ||
| 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 | |||
| 155149 | 176415 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 850 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6001011.08243 | 2088875.9268 | 37.7157126696686 | -122.438432556321 | (37.7157126696686, -122.438432556321) | 9 | 7 | 6 | 28861 | 5 | |||
| 181783 | 176414 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 850 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6001021.05329 | 2088894.22631 | 37.7157634831843 | -122.438399402832 | (37.7157634831843, -122.438399402832) | 9 | 7 | 6 | 28861 | 5 | |||
| 158936 | 101289 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 830 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 6001069.51096 | 2088976.20041 | 37.715991321918 | -122.438237780259 | (37.715991321918, -122.438237780259) | 9 | 7 | 6 | 28861 | 5 | ||||
| 32503 | 176413 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 816 Lisbon St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6001088.39895 | 2089005.35886 | 37.7160724587542 | -122.4381745822 | (37.7160724587542, -122.4381745822) | 9 | 7 | 6 | 28861 | 5 | |||
| 170945 | 58156 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 837 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1978 12:00:00 AM | 9 | Permit Number 17140 | 6001092.2872 | 2088918.12181 | 37.7158331464556 | -122.438154896944 | (37.7158331464556, -122.438154896944) | 9 | 7 | 6 | 28861 | 5 | ||
| 131345 | 58153 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 816 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1978 12:00:00 AM | 2 | Permit Number 17137 | 6001098.08865 | 2089024.55935 | 37.7161257300936 | -122.438142464699 | (37.7161257300936, -122.438142464699) | 9 | 7 | 6 | 28861 | 5 | ||
| 91045 | 58152 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 806 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1978 12:00:00 AM | 11 | Permit Number 17136 | 6001116.27875 | 2089048.95657 | 37.7161937539141 | -122.438081337797 | (37.7161937539141, -122.438081337797) | 9 | 7 | 6 | 28861 | 5 | ||
| 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 | |||
| 100913 | 58155 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 815 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1978 12:00:00 AM | 11 | Permit Number 17139 | 6001141.03185 | 2088999.49301 | 37.7160593457428 | -122.437992238373 | (37.7160593457428, -122.437992238373) | 9 | 7 | 6 | 28861 | 5 | ||
| 137705 | 66878 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 281 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1991 12:00:00 AM | Permit Number 30189 | 6001145.91509222 | 2104727.87963003 | 37.7592460999874 | -122.439101967223 | (37.7592460999874, -122.439101967223) | 2 | 4 | 5 | 28862 | 3 | ||
| 156839 | 58154 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 807 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1978 12:00:00 AM | 10 | Permit Number 17138 | 6001157.22948 | 2089029.0056 | 37.7161413018433 | -122.43793836449 | (37.7161413018433, -122.43793836449) | 9 | 7 | 6 | 28861 | 5 | ||
| 123454 | 59623 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 445 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/1988 12:00:00 AM | Permit Number 19030 | 6001158.23229918 | 2110194.44132426 | 37.7742566261049 | -122.439451230631 | (37.7742566261049, -122.439451230631) | 15 | 5 | 11 | 29492 | 10 | ||
| 114821 | 92018 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 4182 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001163 | 2105841 | 37.7623034284238 | -122.439122658321 | (37.7623034284238, -122.439122658321) | 15 | 5 | 5 | 28862 | 3 | ||||
| 15629 | 66830 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 393 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1991 12:00:00 AM | Permit Number 30127 | 6001175.80343985 | 2104102.01378806 | 37.7575293253254 | -122.438953746382 | (37.7575293253254, -122.438953746382) | 2 | 4 | 5 | 28862 | 3 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 32783 | 62137 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 127 San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/31/1985 12:00:00 AM | Permit Number 22247 | 6001408.1074829 | 2092199.32717361 | 37.7248605551976 | -122.437298087712 | (37.7248605551976, -122.437298087712) | 9 | 7 | 6 | 28861 | 25 | ||
| 23930 | 15770 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 4770 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2007 12:00:00 AM | 3 | 3X3 | 6001421.7162 | 2091049.3752 | 37.7217038208164 | -122.437168746584 | (37.7217038208164, -122.437168746584) | 9 | 7 | 6 | 28861 | 25 | ||
| 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 | |||
| 146304 | 63405 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 4330 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/11/1987 12:00:00 AM | Permit Number 23987 | 6001641.42159443 | 2104703.75073536 | 37.7592080301488 | -122.437386541918 | (37.7592080301488, -122.437386541918) | 2 | 4 | 5 | 28862 | 3 | ||
| 76206 | 63396 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 4326 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/11/1987 12:00:00 AM | Permit Number 23978 | 6001653.34817436 | 2104704.40880226 | 37.759210515065 | -122.437345341266 | (37.759210515065, -122.437345341266) | 2 | 4 | 5 | 28862 | 3 |
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) );