trees
969 rows where qSpecies_id = 97 sorted by rowid
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19967 | 101427 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
20155 | 98985 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 847 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009438.4 | 2115684 | 37.7897973999496 | -122.411196371815 | (37.7897973999496, -122.411196371815) | 5 | 1 | 10 | 28857 | 21 | ||||
20417 | 224687 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3513 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006398.66183 | 2101411.28771 | 37.7504369894718 | -122.420699953558 | (37.7504369894718, -122.420699953558) | 2 | 4 | 5 | 28859 | 19 | |||
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 | ||
20642 | 62333 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 54 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/1985 12:00:00 AM | Permit Number 22475 | 6005123.90294191 | 2096395.98906268 | 37.7365941933288 | -122.424751419367 | (37.7365941933288, -122.424751419367) | 2 | 7 | 5 | 28859 | 2 | ||
21188 | 34146 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 3 | 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 | |||
22276 | 224570 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3235 18th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007990.36824 | 2105589.83292 | 37.7619999031047 | -122.415491498431 | (37.7619999031047, -122.415491498431) | 2 | 4 | 7 | 28859 | 19 | |||
22488 | 98718 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1500@Polk Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | 13 | 9 | 10 | 28858 | 32 | |||||
22962 | 224637 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 343 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006160.37028 | 2098038.58649 | 37.741162883772 | -122.421284510199 | (37.741162883772, -122.421284510199) | 2 | 7 | 7 | 28859 | 2 | |||
23053 | 48044 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
23293 | 101516 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 610 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 28301 | 6008387 | 2114552 | 37.7866301828456 | -122.414753982265 | (37.7866301828456, -122.414753982265) | 5 | 1 | 10 | 28858 | 36 | ||
23294 | 224483 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1500 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6007282.93524 | 2107366.34912 | 37.7668380128917 | -122.418064187227 | (37.7668380128917, -122.418064187227) | 8 | 4 | 7 | 28853 | 19 | |||
23581 | 31969 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 470 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1995 12:00:00 AM | Permit Number 35370 | 6009517.59351868 | 2092163.53246737 | 37.7252199449059 | -122.409261897755 | (37.7252199449059, -122.409261897755) | 9 | 3 | 7 | 309 | 28 | |||
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 | ||
24214 | 64582 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3646 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1988 12:00:00 AM | 18 | 7x12 | Permit Number 25481 | 6005989.81318517 | 2104358.59934784 | 37.758506573723 | -122.422323167129 | (37.758506573723, -122.422323167129) | 2 | 4 | 5 | 28859 | 19 | |
24232 | 218833 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991183.94041 | 2098426.02106 | 37.7413709589947 | -122.473095372371 | (37.7413709589947, -122.473095372371) | 1 | 8 | 4 | 29491 | 40 | |||
24474 | 62335 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 88 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/1985 12:00:00 AM | Permit Number 22477 | 6005278.45102522 | 2096412.38253023 | 37.7366479337699 | -122.424218245392 | (37.7366479337699, -122.424218245392) | 2 | 7 | 7 | 28859 | 2 | ||
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 | |||
24922 | 224531 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3077 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008520.36157 | 2102113.23947 | 37.752483743936 | -122.413412573453 | (37.752483743936, -122.413412573453) | 2 | 4 | 7 | 28859 | 19 | |||
25118 | 224700 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3230 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 3ft | 6007513.40637 | 2102105.84325 | 37.7524068465217 | -122.416894278962 | (37.7524068465217, -122.416894278962) | 2 | 4 | 7 | 28859 | 19 | |||
25421 | 226491 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2450 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6008819.81577 | 2104185.8103 | 37.7581913641506 | -122.412523500065 | (37.7581913641506, -122.412523500065) | 2 | 4 | 7 | 28859 | 19 | |||
25611 | 224697 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3186 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6007787.21683 | 2102109.23167 | 37.7524315481913 | -122.415947634593 | (37.7524315481913, -122.415947634593) | 2 | 4 | 7 | 28859 | 19 | |||
25618 | 101054 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 760 Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008077 | 2114493 | 37.7864507606031 | -122.415822330961 | (37.7864507606031, -122.415822330961) | 13 | 1 | 9 | 28858 | 36 | |||
25718 | 176421 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 526 Lathrop Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6013003.58559 | 2086544.76512 | 37.7099866196603 | -122.396817348641 | (37.7099866196603, -122.396817348641) | 10 | 3 | 8 | 309 | 1 | |||
25933 | 60830 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 282 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | 22 | Permit Number 20603 | 6004748.95976393 | 2102035.39189802 | 37.7520575177016 | -122.426449179292 | (37.7520575177016, -122.426449179292) | 2 | 4 | 5 | 28862 | 22 | |
26012 | 642 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3225 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6007512.22413 | 2102054.36572 | 37.7522654344184 | -122.416894720512 | (37.7522654344184, -122.416894720512) | 2 | 4 | 7 | 28859 | 19 | |||
26097 | 53744 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 180 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | Permit Number 37696 | 6007052.84530249 | 2097996.95756942 | 37.7410988557538 | -122.41819569379 | (37.7410988557538, -122.41819569379) | 2 | 7 | 7 | 28859 | 2 | |||
26145 | 258009 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 380 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005531 | 2111189 | 37.7772353303506 | -122.424395772149 | (37.7772353303506, -122.424395772149) | 7 | 9 | 11 | 28852 | 10 | ||||
26673 | 48040 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
26923 | 101895 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 590X Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011780 | 2117743.1 | 37.795582240012 | -122.403239519119 | (37.795582240012, -122.403239519119) | 3 | 1 | 10 | 28860 | 4 | ||||
27007 | 224588 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2765 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008276.68417 | 2106776.83741 | 37.7652752322039 | -122.414585240843 | (37.7652752322039, -122.414585240843) | 8 | 4 | 7 | 28859 | 19 | |||
27124 | 33817 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1201 California St | 2 | 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 | |||
27367 | 62428 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 223 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1986 12:00:00 AM | Permit Number 22976 | 6003655.90381046 | 2109145.69391809 | 37.7715188511616 | -122.430736479427 | (37.7715188511616, -122.430736479427) | 15 | 9 | 11 | 29492 | 10 | ||
27423 | 121150 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1918 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 24 | 6004687.86766006 | 2107227.29036829 | 37.766309789845 | -122.427030199286 | (37.766309789845, -122.427030199286) | 8 | 4 | 5 | 28862 | 3 | |||
27553 | 97723 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 2 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | ||
27637 | 224594 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3133 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/1981 12:00:00 AM | 14 | Width 3ft | Permit Number 18871 | 6005947.45622 | 2106648.22226 | 37.7647909508601 | -122.42263236011 | (37.7647909508601, -122.42263236011) | 8 | 4 | 5 | 28859 | 19 | |
27707 | 66488 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1043 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | Permit Number 29647 | 6007587.84875499 | 2109703.11754078 | 37.7732713850209 | -122.417175139527 | (37.7732713850209, -122.417175139527) | 8 | 2 | 9 | 28853 | 19 | ||
27714 | 66042 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 303 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/1990 12:00:00 AM | Permit Number 29081 | 6002303.92307718 | 2106443.08966771 | 37.7640214741501 | -122.435219706112 | (37.7640214741501, -122.435219706112) | 15 | 5 | 5 | 28862 | 3 | ||
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 | ||||
27966 | 173643 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 657 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012793 | 2114089 | 37.7856054636163 | -122.399477673173 | (37.7856054636163, -122.399477673173) | 6 | 2 | 9 | 28853 | 6 | ||||
28013 | 33609 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 308 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37721 | 6005048.76551317 | 2110086.28535746 | 37.7741803016618 | -122.425985460117 | (37.7741803016618, -122.425985460117) | 7 | 9 | 11 | 28852 | 10 | |||
28050 | 224521 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007845.31387 | 2105404.79187 | 37.7614836688504 | -122.415980082123 | (37.7614836688504, -122.415980082123) | 2 | 4 | 7 | 28859 | 19 | |||
28430 | 224645 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 7 Heyman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6006421.94544 | 2098375.74609 | 37.742103392067 | -122.420404001067 | (37.742103392067, -122.420404001067) | 2 | 7 | 7 | 28859 | 2 | |||
28593 | 66848 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 919 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1991 12:00:00 AM | Permit Number 30152 | 6008182.6560056 | 2115155.17049763 | 37.7882748588768 | -122.415503684404 | (37.7882748588768, -122.415503684404) | 13 | 1 | 10 | 28858 | 21 | ||
28762 | 218828 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 831 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5990524.89237 | 2100389.62216 | 37.7467243191683 | -122.475517447198 | (37.7467243191683, -122.475517447198) | 1 | 8 | 4 | 29491 | 40 | |||
28862 | 224598 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3375 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6005862.87598 | 2103720.88852 | 37.7567484073338 | -122.422716854995 | (37.7567484073338, -122.422716854995) | 2 | 4 | 5 | 28859 | 19 | |||
28999 | 224659 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1086 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6009169.14858 | 2102873.09479 | 37.7546065423583 | -122.41122262175 | (37.7546065423583, -122.41122262175) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||
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 | ||
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 | ||||
29906 | 224646 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 9 Heyman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6006447.48473 | 2098360.83948 | 37.7420639010279 | -122.420314636308 | (37.7420639010279, -122.420314636308) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
30050 | 104403 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2362 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 3x3 | Permit Number 24809 | 6002031 | 2107070 | 37.7657273142687 | -122.436208531898 | (37.7657273142687, -122.436208531898) | 15 | 5 | 5 | 28862 | 3 | |
30056 | 250762 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 231 32nd Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5985862.1127 | 2114339.73432 | 37.7847560253059 | -122.492667897222 | (37.7847560253059, -122.492667897222) | 11 | 6 | 1 | 55 | 33 | |||
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 | |||||
30353 | 105684 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 1 | Front Yard : Pot | Tree | Private 2 | 10 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
30441 | 116039 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1401x Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6008038.31567 | 2116541.76159 | 37.7920739841803 | -122.416101317043 | (37.7920739841803, -122.416101317043) | 5 | 1 | 10 | 28858 | 21 | |||
30487 | 99178 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 330 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008617 | 2122137 | 37.807469636787 | -122.41449515712 | (37.807469636787, -122.41449515712) | 3 | 1 | 10 | 308 | 23 | ||||
30525 | 109918 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 114 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | 6010269.5 | 2121152.3 | 37.8048585915517 | -122.408706764133 | (37.8048585915517, -122.408706764133) | 3 | 1 | 10 | 308 | 23 | ||||
30771 | 101430 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
31188 | 116841 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2344 15TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 24 | 6002015 | 2107091 | 37.7657840660528 | -122.436265375372 | (37.7657840660528, -122.436265375372) | 15 | 5 | 5 | 28862 | 3 | |||
31415 | 34159 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 12 | 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 | |||
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 | |||
31709 | 224519 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007848.49243 | 2105359.1644 | 37.7613585650588 | -122.415965857533 | (37.7613585650588, -122.415965857533) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
32511 | 117226 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
32764 | 224689 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3514 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006377.96332 | 2101451.22022 | 37.7505454684046 | -122.420774365244 | (37.7505454684046, -122.420774365244) | 2 | 4 | 5 | 28859 | 19 | |||
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 | ||
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 | |||
33251 | 105685 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 2 | Front Yard : Pot | Tree | Private 2 | 8 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
33799 | 112160 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1328 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6013587.23518 | 2105720.84823 | 37.7626726418425 | -122.396143156607 | (37.7626726418425, -122.396143156607) | 14 | 3 | 8 | 28856 | 29 | |||
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 | ||||
34968 | 258294 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2498X 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991168 | 2098442 | 37.7414139101312 | -122.473151653247 | (37.7414139101312, -122.473151653247) | 1 | 8 | 4 | 29491 | 40 | ||||
35053 | 224682 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1390 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6006417.42588 | 2101484.35178 | 37.7506386642487 | -122.420640252069 | (37.7506386642487, -122.420640252069) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
36236 | 48046 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
36324 | 102902 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 290 PACIFIC AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6012556 | 2118523 | 37.797766966668 | -122.400609219963 | (37.797766966668, -122.400609219963) | 3 | 1 | 10 | 28860 | 6 | ||||
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 | |||
36516 | 226493 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2300 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008772.32666 | 2104949.65017 | 37.7602860290962 | -122.41274173856 | (37.7602860290962, -122.41274173856) | 2 | 4 | 7 | 28859 | 19 | |||
36749 | 122752 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 693 Vermont St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 6011278.80569 | 2105286.3398 | 37.7613508668666 | -122.404096651066 | (37.7613508668666, -122.404096651066) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||
37042 | 224690 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3514 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006361.82473 | 2101451.21677 | 37.750544549297 | -122.420830173598 | (37.750544549297, -122.420830173598) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
37424 | 48789 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
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 | |||
38079 | 53067 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2161 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2006 12:00:00 AM | Permit Number 49038 | 6002271.52116096 | 2114331.58955378 | 37.7856794886217 | -122.435896249645 | (37.7856794886217, -122.435896249645) | 13 | 6 | 11 | 29490 | 13 |
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) );