trees
356 rows where qSpecies_id = 91 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
63489 | 113030 | Undocumented 4 | Schinus molle :: California Pepper 91 | 200x ESMERALDA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 9x9 | 6007093 | 2098828 | 37.7433829729046 | -122.41811575542 | (37.7433829729046, -122.41811575542) | 2 | 7 | 7 | 28859 | 2 | |||
81470 | 61782 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 2107 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1985 12:00:00 AM | 20 | Permit Number 21804 | 6012179.15182 | 2102325.12749 | 37.7532702936903 | -122.400774668711 | (37.7532702936903, -122.400774668711) | 10 | 3 | 8 | 28856 | 29 | |
57476 | 55227 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 211 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/1972 12:00:00 AM | 13 | Permit Number 11145 | 5988668.09914 | 2113889.94192 | 37.7836846949952 | -122.48292724876 | (37.7836846949952, -122.48292724876) | 11 | 6 | 2 | 55 | 26 | ||
108016 | 239647 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 211 Cumberland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004225.35965 | 2104505.85925 | 37.7588112263749 | -122.428435935269 | (37.7588112263749, -122.428435935269) | 2 | 4 | 5 | 28862 | 3 | |||
114058 | 239648 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 211 Cumberland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004246.22251 | 2104509.47954 | 37.7588223473949 | -122.42836403987 | (37.7588223473949, -122.42836403987) | 2 | 4 | 5 | 28862 | 3 | |||
179689 | 239646 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 211 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004207.2629 | 2104504.88213 | 37.7588075193625 | -122.428498452559 | (37.7588075193625, -122.428498452559) | 2 | 4 | 5 | 28862 | 3 | |||
177046 | 239605 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 217 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5997066.3771 | 2107014.18212 | 37.7652907329028 | -122.453375969329 | (37.7652907329028, -122.453375969329) | 15 | 5 | 11 | 29492 | 12 | |||
159362 | 68308 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2178 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 0 | Permit Number 32119 | 5981736.58109187 | 2100266.85539552 | 37.7458738657157 | -122.505896923616 | (37.7458738657157, -122.505896923616) | 1 | 8 | 3 | 29491 | 35 | |
59175 | 46762 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 220 Esmeralda Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | 14 | 6x5 | Permit Number 44860 | 6007156.68652731 | 2098808.76351871 | 37.7433337382313 | -122.417894179823 | (37.7433337382313, -122.417894179823) | 2 | 7 | 7 | 28859 | 2 |
98903 | 239612 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 220 Esmeralda Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007237.85888 | 2098768.99356 | 37.7432291067493 | -122.417610687906 | (37.7432291067493, -122.417610687906) | 2 | 7 | 7 | 28859 | 2 | |||
8068 | 32395 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 222 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | 6 | 8x6 | Permit Number 36936 | 6005810.68419 | 2096104.55108 | 37.735832735077 | -122.42235621788 | (37.735832735077, -122.42235621788) | 2 | 7 | 7 | 28859 | 2 |
59784 | 45068 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2227 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | 4 | Permit Number 43949 | 5987902.9352 | 2100130.6194 | 37.7458608246267 | -122.4845648054 | (37.7458608246267, -122.4845648054) | 1 | 8 | 3 | 29491 | 35 | |
33981 | 59467 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 225 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1980 12:00:00 AM | Permit Number 18832 | 6003936.96875248 | 2095250.30733216 | 37.7333813011767 | -122.428773510363 | (37.7333813011767, -122.428773510363) | 9 | 7 | 5 | 28861 | 25 | |||
122194 | 239589 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 225 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003864.64018 | 2095248.99329 | 37.7333735991966 | -122.429023476774 | (37.7333735991966, -122.429023476774) | 9 | 7 | 5 | 28861 | 25 | |||
23648 | 239611 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 230 Esmeralda Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6007188.60592 | 2098802.03139 | 37.7433170496408 | -122.417783333431 | (37.7433170496408, -122.417783333431) | 2 | 7 | 7 | 28859 | 2 | |||
98928 | 136366 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2323 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001763.72183 | 2119055.52403 | 37.7986213292711 | -122.437991580064 | (37.7986213292711, -122.437991580064) | 13 | 9 | 1 | 57 | 17 | |||
152697 | 244482 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 235 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6001259.6239 | 2109499.111 | 37.7723531930337 | -122.43905065598 | (37.7723531930337, -122.43905065598) | 15 | 5 | 11 | 29492 | 9 | |||
178192 | 64253 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 238 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25052 | 6004384.37597616 | 2098713.60490953 | 37.7429160426191 | -122.427473340495 | (37.7429160426191, -122.427473340495) | 2 | 7 | 5 | 63 | 22 | ||
13005 | 40812 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 240 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1999 12:00:00 AM | Permit Number 41757 | 5994290.46519005 | 2095120.08849436 | 37.732473059968 | -122.462114481375 | (37.732473059968, -122.462114481375) | 9 | 8 | 4 | 59 | 40 | |||
149656 | 40810 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 240 Maywood Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1999 12:00:00 AM | Permit Number 41757 | 5994290.46519005 | 2095120.08849436 | 37.732473059968 | -122.462114481375 | (37.732473059968, -122.462114481375) | 9 | 8 | 4 | 59 | 40 | |||
6035 | 264650 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2400 Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014365 | 2092317 | 37.7259117231873 | -122.392515496721 | (37.7259117231873, -122.392515496721) | 10 | 3 | 8 | 58 | 1 | ||||
7042 | 264648 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2400 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014365 | 2092317 | 37.7259117231873 | -122.392515496721 | (37.7259117231873, -122.392515496721) | 10 | 3 | 8 | 58 | 1 | ||||
7939 | 264649 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2400 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014365 | 2092317 | 37.7259117231873 | -122.392515496721 | (37.7259117231873, -122.392515496721) | 10 | 3 | 8 | 58 | 1 | ||||
17499 | 264647 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2400 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014365 | 2092317 | 37.7259117231873 | -122.392515496721 | (37.7259117231873, -122.392515496721) | 10 | 3 | 8 | 58 | 1 | ||||
129788 | 239614 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 249 Precita Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007957.74109 | 2100292.59771 | 37.7474530659031 | -122.41522934697 | (37.7474530659031, -122.41522934697) | 2 | 7 | 7 | 28859 | 2 | |||
151790 | 63720 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 249 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1987 12:00:00 AM | 12 | 3x3 | Permit Number 24385 | 6008064.48787212 | 2100278.68429699 | 37.7474208614245 | -122.41485923795 | (37.7474208614245, -122.41485923795) | 2 | 7 | 7 | 28859 | 2 |
188533 | 239615 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 249 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007977.56297 | 2100289.57669 | 37.7474458848375 | -122.4151605902 | (37.7474458848375, -122.4151605902) | 2 | 7 | 7 | 28859 | 2 | |||
99414 | 214166 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 25 Hazelwood Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5996590.09341 | 2093838.6494 | 37.729086671304 | -122.454071648891 | (37.729086671304, -122.454071648891) | 9 | 7 | 4 | 28861 | 40 | |||
71330 | 42296 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 250 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 7 | 4x5 | Permit Number 42524 | 5999448.10009127 | 2093930.90110115 | 37.7295034375942 | -122.444197952384 | (37.7295034375942, -122.444197952384) | 9 | 7 | 4 | 63 | 40 |
136689 | 214160 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 250 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5999436.94421 | 2094022.09374 | 37.7297531948487 | -122.44424306977 | (37.7297531948487, -122.44424306977) | 9 | 7 | 4 | 63 | 40 | |||
179865 | 214168 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 250 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994367.37708 | 2095058.85535 | 37.7323093567717 | -122.46184414221 | (37.7323093567717, -122.46184414221) | 9 | 8 | 4 | 59 | 40 | |||
11956 | 72875 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2506 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5989254.9412 | 2098243.205 | 37.7407571191622 | -122.47975172868 | (37.7407571191622, -122.47975172868) | 1 | 8 | 3 | 29491 | 35 | |||
40288 | 239571 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 254 Day St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 3ft | 6004273.21361 | 2098704.8278 | 37.742885654747 | -122.427857083959 | (37.742885654747, -122.427857083959) | 2 | 7 | 5 | 63 | 22 | |||
76751 | 49937 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2591 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2003 12:00:00 AM | 4 | Permit Number 46696 | 5988296.2269 | 2097703.198 | 37.7392186595719 | -122.483026991295 | (37.7392186595719, -122.483026991295) | 1 | 8 | 3 | 29491 | 35 | |
59190 | 183549 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2593 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5989226.3762 | 2097721.7265 | 37.7393236152619 | -122.479812344828 | (37.7393236152619, -122.479812344828) | 1 | 8 | 3 | 29491 | 35 | |||
147452 | 183550 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2593 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5989227.3726 | 2097702.4617 | 37.7392707770079 | -122.479807490437 | (37.7392707770079, -122.479807490437) | 1 | 8 | 3 | 29491 | 35 | |||
169066 | 239666 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 260 Beacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6002994.59568 | 2097812.95314 | 37.7403643577184 | -122.432214505197 | (37.7403643577184, -122.432214505197) | 2 | 7 | 5 | 63 | 7 | |||
187275 | 136365 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2624 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6000330.31034 | 2118901.65056 | 37.7981172142989 | -122.442940566381 | (37.7981172142989, -122.442940566381) | 13 | 9 | 1 | 57 | 17 | |||
54411 | 214169 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 266 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000318.85701 | 2094968.44865 | 37.7324019411004 | -122.441262082491 | (37.7324019411004, -122.441262082491) | 9 | 7 | 5 | 63 | 40 | |||
104997 | 245452 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2700 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6008618.5823 | 2106848.9813 | 37.7654925250272 | -122.413407794567 | (37.7654925250272, -122.413407794567) | 8 | 4 | 7 | 28853 | 19 | |||
26202 | 32764 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 274 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1996 12:00:00 AM | Permit Number 37139 | 5995268.23997636 | 2113729.87048347 | 37.7836270090334 | -122.460081822154 | (37.7836270090334, -122.460081822154) | 11 | 6 | 2 | 54 | 11 | |||
159315 | 32765 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 274 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1996 12:00:00 AM | Permit Number 37139 | 5995268.23997636 | 2113729.87048347 | 37.7836270090334 | -122.460081822154 | (37.7836270090334, -122.460081822154) | 11 | 6 | 2 | 54 | 11 | |||
115611 | 214163 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 274 Tara St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997748.47431 | 2090294.62139 | 37.7194219549502 | -122.449811751014 | (37.7194219549502, -122.449811751014) | 9 | 8 | 6 | 28861 | 24 | |||
116574 | 239573 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 282 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6004076.80225 | 2099571.54345 | 37.7452543431158 | -122.428597987734 | (37.7452543431158, -122.428597987734) | 2 | 7 | 5 | 63 | 22 | |||
189872 | 60508 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 282 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | 3x3 | Permit Number 24310 | 6004065.51901322 | 2099574.2006491 | 37.7452610006153 | -122.428637192649 | (37.7452610006153, -122.428637192649) | 2 | 7 | 5 | 63 | 22 | |
52524 | 136373 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2858 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5999883.33678 | 2117451.31751 | 37.7941094908262 | -122.444382936819 | (37.7941094908262, -122.444382936819) | 13 | 9 | 1 | 57 | 27 | |||
61318 | 136374 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2858 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5999876.11536 | 2117451.30478 | 37.7941090438496 | -122.444407922699 | (37.7941090438496, -122.444407922699) | 13 | 9 | 1 | 57 | 27 | |||
43385 | 136376 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2880 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 5999781.6675 | 2117438.62155 | 37.7940688297731 | -122.444733809114 | (37.7940688297731, -122.444733809114) | 13 | 9 | 1 | 57 | 27 | |||
133494 | 136375 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2880 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5999802.94718 | 2117441.8408 | 37.7940788832989 | -122.44466041095 | (37.7940788832989, -122.44466041095) | 13 | 9 | 1 | 57 | 27 | |||
48059 | 202092 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 29 Carr St | 1 | : | Tree | Private 2 | 20 | Width 3ft | 6013102.77465 | 2090939.87812 | 37.7220602474585 | -122.396782452268 | (37.7220602474585, -122.396782452268) | 10 | 3 | 8 | 58 | 1 | |||
31200 | 53044 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2006 12:00:00 AM | 11 | 3x3 | Permit Number 49022 | 6000981.43692 | 2118569.50402 | 37.797242328631 | -122.440663646636 | (37.797242328631, -122.440663646636) | 13 | 9 | 1 | 57 | 17 | |
34897 | 136370 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6000983.74683 | 2118556.26599 | 37.7972061120278 | -122.440654703763 | (37.7972061120278, -122.440654703763) | 13 | 9 | 1 | 57 | 17 | |||
46065 | 136368 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000986.41607 | 2118529.18744 | 37.797131913463 | -122.440643524276 | (37.797131913463, -122.440643524276) | 13 | 9 | 1 | 57 | 17 | |||
107727 | 136369 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6000984.79842 | 2118544.66291 | 37.7971743129098 | -122.440650232318 | (37.7971743129098, -122.440650232318) | 13 | 9 | 1 | 57 | 17 | |||
131919 | 239655 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 315 Sanchez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6003584.30488 | 2106480.06785 | 37.7641956329586 | -122.430793883956 | (37.7641956329586, -122.430793883956) | 8 | 4 | 5 | 28862 | 3 | |||
5132 | 239574 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 322 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | 12x9 | 6003766 | 2099569 | 37.7452297653441 | -122.429672508032 | (37.7452297653441, -122.429672508032) | 2 | 7 | 5 | 63 | 22 | |||
96303 | 110276 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3364 25TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/2015 12:00:00 AM | 3 | 5x5 | Permit Number 775124 | 6007285 | 2101529 | 37.7508101157283 | -122.417643266234 | (37.7508101157283, -122.417643266234) | 2 | 4 | 7 | 28859 | 19 | |
44107 | 111384 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 340 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x5 | 6014593.21542 | 2112428.75748 | 37.7811469919725 | -122.393133189548 | (37.7811469919725, -122.393133189548) | 6 | 2 | 9 | 28856 | 6 | |||
161220 | 244226 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 340 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003259.6765 | 2109534.4722 | 37.7725638844758 | -122.432134818626 | (37.7725638844758, -122.432134818626) | 15 | 9 | 11 | 29492 | 10 | |||
17752 | 70594 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 342 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6004127.79616 | 2091299.57805 | 37.7225442769693 | -122.427832358882 | (37.7225442769693, -122.427832358882) | 9 | 7 | 6 | 28861 | 5 | |||
98484 | 239610 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 342 Prospect Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 3ft | 6006341.94877 | 2097874.88988 | 37.7407236449682 | -122.420645058033 | (37.7407236449682, -122.420645058033) | 2 | 7 | 7 | 28859 | 2 | |||
89962 | 239567 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3435 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6006895.64188 | 2100851.73373 | 37.7489285791008 | -122.418941674643 | (37.7489285791008, -122.418941674643) | 2 | 4 | 7 | 28859 | 19 | |||
60508 | 239566 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3441 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6006878.39898 | 2100850.62787 | 37.748924571708 | -122.419001222341 | (37.748924571708, -122.419001222341) | 2 | 4 | 7 | 28859 | 19 | |||
94142 | 46335 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3441 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2002 12:00:00 AM | Permit Number 44585 | 6006853.77058428 | 2100846.52070985 | 37.7489119074947 | -122.419086096292 | (37.7489119074947, -122.419086096292) | 2 | 4 | 7 | 28859 | 19 | ||
11330 | 166753 | Planning Code 138.1 required 2 | Schinus molle :: California Pepper 91 | 350 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2019 12:00:00 AM | 3 | 4x4 | Permit Number 781737 | 6002856.72425 | 2101550.76622 | 37.7506197011549 | -122.43295818429 | (37.7506197011549, -122.43295818429) | 2 | 4 | 5 | 28862 | 22 | |
128342 | 239654 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3512 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6004884 | 2103735 | 37.7567318772846 | -122.42610317358 | (37.7567318772846, -122.42610317358) | 2 | 4 | 5 | 28862 | 3 | |||
155796 | 239653 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3512 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6004899.76423 | 2103707.095 | 37.7566561476773 | -122.426046668635 | (37.7566561476773, -122.426046668635) | 2 | 4 | 5 | 28862 | 3 | |||
136874 | 136371 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3518 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002669.28578 | 2120724.92735 | 37.8032565295236 | -122.434977502225 | (37.8032565295236, -122.434977502225) | 13 | 9 | 1 | 57 | 17 | |||
148920 | 69361 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3518 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 8 | Permit Number 33455 | 6002672.47282 | 2120707.16348 | 37.8032079355658 | -122.4349652022 | (37.8032079355658, -122.4349652022) | 13 | 9 | 1 | 57 | 17 | |
132367 | 69363 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3524 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 12 | Permit Number 33457 | 6002667.84891 | 2120741.39075 | 37.8033016521051 | -122.434983652687 | (37.8033016521051, -122.434983652687) | 13 | 9 | 1 | 57 | 17 | |
146750 | 239581 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3537 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004768.88841 | 2103660.24792 | 37.756520118925 | -122.426495949253 | (37.756520118925, -122.426495949253) | 2 | 4 | 5 | 28862 | 22 | |||
319 | 96811 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 356 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996379.5 | 2106960.2 | 37.7651031164685 | -122.455747798641 | (37.7651031164685, -122.455747798641) | 15 | 5 | 11 | 29492 | 12 | ||||
185878 | 32430 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 36 Tingley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/1996 12:00:00 AM | 16 | Permit Number 36957 | 6002798.58811 | 2093563.75666 | 37.7286859198974 | -122.432588778773 | (37.7286859198974, -122.432588778773) | 9 | 7 | 6 | 28861 | 25 | ||
152333 | 239639 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3615 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004229.58112 | 2103632.14382 | 37.7564124493922 | -122.428359063024 | (37.7564124493922, -122.428359063024) | 2 | 4 | 5 | 28862 | 22 | |||
51524 | 239649 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3616 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004202.79012 | 2103671.51063 | 37.7565190253373 | -122.428454521557 | (37.7565190253373, -122.428454521557) | 2 | 4 | 5 | 28862 | 3 | |||
128408 | 239640 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3627 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004151.81834 | 2103627.38126 | 37.756394971966 | -122.428627654542 | (37.756394971966, -122.428627654542) | 2 | 4 | 5 | 28862 | 22 | |||
33437 | 239641 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3637 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004113.74882 | 2103625.61972 | 37.7563879806327 | -122.428759186701 | (37.7563879806327, -122.428759186701) | 2 | 4 | 5 | 28862 | 22 | |||
93453 | 53873 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3669 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1987 12:00:00 AM | Permit Number 24724 | 6003927.57680575 | 2103608.86941248 | 37.7563314496504 | -122.429401840118 | (37.7563314496504, -122.429401840118) | 2 | 4 | 5 | 28862 | 22 | ||
112273 | 179424 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 367 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6005868 | 2092014 | 37.7246042151677 | -122.421867578972 | (37.7246042151677, -122.421867578972) | 9 | 7 | 7 | 309 | 5 | |||
13603 | 239638 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3689 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003857.31467 | 2103604.80906 | 37.7563163226577 | -122.429644541356 | (37.7563163226577, -122.429644541356) | 2 | 4 | 5 | 28862 | 22 | |||
23040 | 239637 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3691 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003808.38299 | 2103603.27195 | 37.7563093313217 | -122.429813654389 | (37.7563093313217, -122.429813654389) | 2 | 4 | 5 | 28862 | 22 | |||
89326 | 239635 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3691 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003778.26076 | 2103599.43748 | 37.7562970969591 | -122.429917553956 | (37.7562970969591, -122.429917553956) | 2 | 4 | 5 | 28862 | 22 | |||
189202 | 239636 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3691 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003794.28038 | 2103601.33494 | 37.7563032141343 | -122.429862287926 | (37.7563032141343, -122.429862287926) | 2 | 4 | 5 | 28862 | 22 | |||
63916 | 239643 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 37 Ford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003364.63638 | 2105630.60252 | 37.7618507577208 | -122.431493007021 | (37.7618507577208, -122.431493007021) | 15 | 4 | 5 | 28862 | 3 | |||
71031 | 239642 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 37 Ford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6003350.6343 | 2105630.89155 | 37.7618507577148 | -122.431541455278 | (37.7618507577148, -122.431541455278) | 15 | 4 | 5 | 28862 | 3 | |||
35105 | 46070 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3746 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2001 12:00:00 AM | Permit Number 44454 | 6003440.19743527 | 2103634.04731282 | 37.7563729765603 | -122.431089163341 | (37.7563729765603, -122.431089163341) | 2 | 4 | 5 | 28862 | 3 | |||
136995 | 46069 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3746 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2001 12:00:00 AM | Permit Number 44454 | 6003440.19743527 | 2103634.04731282 | 37.7563729765603 | -122.431089163341 | (37.7563729765603, -122.431089163341) | 2 | 4 | 5 | 28862 | 3 | |||
138709 | 52003 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 375 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/2005 12:00:00 AM | Permit Number 48220 | 6004122.23435698 | 2098354.44856915 | 37.7419150515767 | -122.428354161004 | (37.7419150515767, -122.428354161004) | 2 | 7 | 5 | 63 | 7 | ||
164036 | 46334 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3776 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2002 12:00:00 AM | Permit Number 44584 | 6005338.11992395 | 2101398.90311865 | 37.7503431540329 | -122.424366507573 | (37.7503431540329, -122.424366507573) | 2 | 4 | 5 | 28859 | 19 | ||
4861 | 40879 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 38 Washburn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1976 12:00:00 AM | Permit Number 41789 | 6008346.99191908 | 2110451.53839796 | 37.775369049965 | -122.414602124139 | (37.775369049965, -122.414602124139) | 8 | 2 | 9 | 28853 | 34 | |||
23225 | 239627 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3885 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002571.81479 | 2103540.6818 | 37.7560673714328 | -122.434085656222 | (37.7560673714328, -122.434085656222) | 2 | 4 | 5 | 28862 | 22 | |||
105314 | 239626 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3885 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6002499.39714 | 2103536.73091 | 37.7560524130043 | -122.434335817949 | (37.7560524130043, -122.434335817949) | 2 | 4 | 5 | 28862 | 22 | |||
121062 | 46566 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3900 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | Permit Number 44701 | 6002455.82917315 | 2102994.91492425 | 37.7545622428397 | -122.434447752947 | (37.7545622428397, -122.434447752947) | 2 | 4 | 5 | 28862 | 22 | |||
109994 | 15661 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3900 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005100.74203 | 2095958.24727 | 37.7353909444416 | -122.424800364285 | (37.7353909444416, -122.424800364285) | 2 | 7 | 5 | 28859 | 2 | |||
29837 | 214153 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 391 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5992476.67943 | 2094212.83068 | 37.7298773579434 | -122.46831913414 | (37.7298773579434, -122.46831913414) | 9 | 8 | 4 | 59 | 40 | |||
193003 | 239631 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3946 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003468.88792 | 2102461.3534 | 37.7531546624799 | -122.430906252449 | (37.7531546624799, -122.430906252449) | 2 | 4 | 5 | 28862 | 22 | |||
94236 | 239572 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 396 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6003432.67407 | 2098660.37482 | 37.7427160111273 | -122.43076026277 | (37.7427160111273, -122.43076026277) | 2 | 7 | 5 | 63 | 22 | |||
87375 | 187555 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3960 Somerset St | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 6011363.78669 | 2088352.31881 | 37.714858391064 | -122.402611866762 | (37.714858391064, -122.402611866762) | 10 | 7 | 8 | 309 | 39 | ||||
133977 | 187556 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3960 Somerset St | 3 | Side Yard : Yard | Tree | Private 2 | 23 | 6011365.57696 | 2088364.56073 | 37.7148921048592 | -122.402606539166 | (37.7148921048592, -122.402606539166) | 10 | 7 | 8 | 309 | 39 | ||||
144402 | 187554 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3960 Somerset St | 3 | Side Yard : Yard | Tree | Private 2 | 12 | 6011368.52295 | 2088357.85007 | 37.7148738432156 | -122.402595884908 | (37.7148738432156, -122.402595884908) | 10 | 7 | 8 | 309 | 39 |
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) );