trees
779 rows where qCareAssistant = "" and qSpecies_id = 5 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5594 | 106035 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014366.74772 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | 12 | 2 | 9 | 28855 | 6 | ||||
6377 | 82142 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | 9 | 7 | 4 | 59 | 40 | ||
9140 | 48531 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 500(REVISED) Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45857 | 6007225.9541014 | 2104383.62172477 | 37.7586449307205 | -122.41804980128 | (37.7586449307205, -122.41804980128) | 2 | 4 | 7 | 28859 | 19 | |||
9470 | 46514 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 525or larger Golden Gate Ave In A 24 Box | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2002 12:00:00 AM | Permit Number 44680 | 6007056.20383649 | 2112568.41573989 | 37.7811088818185 | -122.419217465788 | (37.7811088818185, -122.419217465788) | 7 | 9 | 9 | 28852 | 36 | |||
13958 | 262096 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Width 3ft | 6016433.67399 | 2098382.99048 | 37.7426823836985 | -122.385786776164 | (37.7426823836985, -122.385786776164) | 10 | 3 | 8 | 58 | 1 | ||||
29632 | 102874 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2761 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009574.6 | 2103896.5 | 37.7574393136514 | -122.409892695521 | (37.7574393136514, -122.409892695521) | 2 | 4 | 7 | 28859 | 19 | ||||
36090 | 58566 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 119 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/1979 12:00:00 AM | 3x3 | Permit Number 17756 | 5997901.33257876 | 2107130.89979942 | 37.7656590338964 | -122.450496484092 | (37.7656590338964, -122.450496484092) | 15 | 5 | 11 | 29492 | 9 | ||
37802 | 119741 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
37929 | 82121 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 44 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49840 | 5998809.17063994 | 2096527.78133102 | 37.7365973852663 | -122.446593550118 | (37.7365973852663, -122.446593550118) | 9 | 7 | 4 | 59 | 40 | ||
41358 | 115360 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 205 ARKANSAS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6012944 | 2106057 | 37.7635598294353 | -122.398391479388 | (37.7635598294353, -122.398391479388) | 14 | 3 | 8 | 28856 | 29 | ||||
43272 | 105450 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 890 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009082.7 | 2103985.1 | 37.7576550089679 | -122.411600148106 | (37.7576550089679, -122.411600148106) | 2 | 4 | 7 | 28859 | 19 | |||||
44569 | 119744 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
50010 | 85052 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 355x Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/27/2007 12:00:00 AM | Permit Number 49332 | 6004826.8 | 2109751.4 | 37.7732482408903 | -122.426729425627 | (37.7732482408903, -122.426729425627) | 7 | 9 | 11 | 28852 | 10 | |||
52265 | 95955 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 190X Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2011 12:00:00 AM | 3x3 | Permit Number 767637 | 6014675 | 2116143.7 | 37.791351915434 | -122.393110267966 | (37.791351915434, -122.393110267966) | 12 | 2 | 9 | 28855 | 6 | ||
53679 | 56848 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1025 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | 6x5 | Permit Number 14082 | 5998817.86133668 | 2106377.94605096 | 37.7636440271414 | -122.447272227776 | (37.7636440271414, -122.447272227776) | 15 | 5 | 11 | 29492 | 9 | ||
54428 | 50386 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 296 Liberty St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532584 | 37.7573701836913 | -122.427864268021 | (37.7573701836913, -122.427864268021) | 2 | 4 | 5 | 28862 | 3 | |||
54786 | 106031 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 180 Howard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014640.7 | 2115990 | 37.7909279854042 | -122.39321818634 | (37.7909279854042, -122.39321818634) | 12 | 2 | 9 | 28855 | 6 | ||||
61904 | 110184 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 1500x LYON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999718 | 2114083 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | 15 | 6 | 1 | 29490 | 31 | ||||
62148 | 115558 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 2500x 19TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010357 | 2105131 | 37.7608727909959 | -122.407273854716 | (37.7608727909959, -122.407273854716) | 10 | 4 | 8 | 28859 | 19 | ||||
69517 | 48533 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 500(REVISED) Capp St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45857 | 6007225.9541014 | 2104383.62172477 | 37.7586449307205 | -122.41804980128 | (37.7586449307205, -122.41804980128) | 2 | 4 | 7 | 28859 | 19 | |||
70907 | 102876 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2761 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009574.6 | 2103896.5 | 37.7574393136514 | -122.409892695521 | (37.7574393136514, -122.409892695521) | 2 | 4 | 7 | 28859 | 19 | ||||
71727 | 65411 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 81 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/1989 12:00:00 AM | Permit Number 28262 | 6004263.16526256 | 2108931.19399052 | 37.7709642723528 | -122.428620636268 | (37.7709642723528, -122.428620636268) | 7 | 9 | 11 | 29492 | 10 | |||
82931 | 110183 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 1500x LYON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999718 | 2114083 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | 15 | 6 | 1 | 29490 | 31 | ||||
82972 | 110185 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 1500x LYON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999718 | 2114083 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | 15 | 6 | 1 | 29490 | 31 | ||||
85587 | 94581 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1025 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5998825 | 2106371 | 37.763625362932 | -122.447247037522 | (37.763625362932, -122.447247037522) | 15 | 5 | 11 | 29492 | 9 | ||||
86582 | 105449 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 890 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009082.7 | 2103985.1 | 37.7576550089679 | -122.411600148106 | (37.7576550089679, -122.411600148106) | 2 | 4 | 7 | 28859 | 19 | |||||
89068 | 119742 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
94151 | 87254 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 32 McCarthy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50278 | 6007985.7 | 2086740.5 | 37.7102434920179 | -122.414174016703 | (37.7102434920179, -122.414174016703) | 9 | 7 | 8 | 309 | 39 | |||
97684 | 115557 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 2500x 19TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010357 | 2105131 | 37.7608727909959 | -122.407273854716 | (37.7608727909959, -122.407273854716) | 10 | 4 | 8 | 28859 | 19 | ||||
99119 | 50383 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 296 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532584 | 37.7573701836913 | -122.427864268021 | (37.7573701836913, -122.427864268021) | 2 | 4 | 5 | 28862 | 3 | |||
100997 | 173732 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1690x Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015419 | 2098106 | 37.7418656239974 | -122.389275919147 | (37.7418656239974, -122.389275919147) | 10 | 3 | 8 | 58 | 1 | ||||
101550 | 119745 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
103441 | 50384 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 296 Liberty St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532584 | 37.7573701836913 | -122.427864268021 | (37.7573701836913, -122.427864268021) | 2 | 4 | 5 | 28862 | 3 | |||
105981 | 106036 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2015 12:00:00 AM | 3x3 | Permit Number 770222 | 6014366.74772 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | 12 | 2 | 9 | 28855 | 6 | ||
107743 | 54886 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 140 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1972 12:00:00 AM | 3x4 | Permit Number 10751 | 5997750.13061777 | 2107162.33224107 | 37.7657366841835 | -122.451021722872 | (37.7657366841835, -122.451021722872) | 15 | 5 | 11 | 29492 | 9 | ||
112170 | 56845 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 980 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | 4x4 | Permit Number 14078 | 5998833.42862215 | 2106621.08669964 | 37.7643125198309 | -122.447235885769 | (37.7643125198309, -122.447235885769) | 15 | 5 | 11 | 29492 | 9 | ||
113085 | 58721 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 66 Carmelita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1981 12:00:00 AM | Permit Number 19065 | 6002629.53182761 | 2108749.25499909 | 37.7703721248343 | -122.434258404788 | (37.7703721248343, -122.434258404788) | 15 | 5 | 5 | 29492 | 9 | |||
115939 | 82092 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | 9 | 7 | 4 | 59 | 40 | ||
117938 | 105930 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 971 Florida St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009455 | 2103552.4 | 37.7564877890416 | -122.410282026926 | (37.7564877890416, -122.410282026926) | 2 | 4 | 7 | 28859 | 19 | |||||
124822 | 111888 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 140 LUNDYS LN | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x12 | 6006709 | 2098750 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | 2 | 7 | 7 | 28859 | 2 | ||||
129067 | 51546 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 655 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2005 12:00:00 AM | Permit Number 47845 | 6007074.31830792 | 2121880.33708987 | 37.8066781199827 | -122.419815746942 | (37.8066781199827, -122.419815746942) | 5 | 1 | 1 | 28858 | 32 | |||
130611 | 50385 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 296 Liberty St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532584 | 37.7573701836913 | -122.427864268021 | (37.7573701836913, -122.427864268021) | 2 | 4 | 5 | 28862 | 3 | |||
131544 | 59362 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 300 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/1980 12:00:00 AM | Permit Number 18713 | 6001270.92113106 | 2096540.31776103 | 37.7367721171555 | -122.4380831379 | (37.7367721171555, -122.4380831379) | 2 | 7 | 5 | 63 | 7 | |||
131762 | 50388 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 296 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532584 | 37.7573701836913 | -122.427864268021 | (37.7573701836913, -122.427864268021) | 2 | 4 | 5 | 28862 | 3 | |||
133859 | 87253 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2 McCarthy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50277 | 6008031.4 | 2086860.8 | 37.7105763778259 | -122.414024572568 | (37.7105763778259, -122.414024572568) | 9 | 7 | 8 | 309 | 39 | |||
138479 | 85051 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 355x Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/27/2007 12:00:00 AM | Permit Number 49332 | 6004826.8 | 2109751.4 | 37.7732482408903 | -122.426729425627 | (37.7732482408903, -122.426729425627) | 7 | 9 | 11 | 28852 | 10 | |||
139674 | 101042 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 655 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47845 | 6006837 | 2121873 | 37.8066446021589 | -122.420636512845 | (37.8066446021589, -122.420636512845) | 5 | 1 | 1 | 28858 | 32 | ||||
145716 | 101044 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 655 Beach St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47845 | 6006837 | 2121873 | 37.8066446021589 | -122.420636512845 | (37.8066446021589, -122.420636512845) | 5 | 1 | 1 | 28858 | 32 | ||||
146949 | 82141 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | 9 | 7 | 4 | 59 | 40 | ||
147008 | 106033 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014366.74772 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | 12 | 2 | 9 | 28855 | 6 | ||||
149041 | 113693 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 112 LUNDYS LN | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x5 | 6006814 | 2098928 | 37.7436418429474 | -122.419087559811 | (37.7436418429474, -122.419087559811) | 2 | 7 | 7 | 28859 | 2 | ||||
150580 | 82143 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | 9 | 7 | 4 | 59 | 40 | ||
156506 | 101043 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 655 Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47845 | 6006837 | 2121873 | 37.8066446021589 | -122.420636512845 | (37.8066446021589, -122.420636512845) | 5 | 1 | 1 | 28858 | 32 | ||||
161042 | 101045 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 655 Beach St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47845 | 6006837 | 2121873 | 37.8066446021589 | -122.420636512845 | (37.8066446021589, -122.420636512845) | 5 | 1 | 1 | 28858 | 32 | ||||
161298 | 47317 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2524 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2002 12:00:00 AM | Permit Number 45245 | 6010338.92838604 | 2105074.55283943 | 37.7607167883884 | -122.407332377331 | (37.7607167883884, -122.407332377331) | 10 | 4 | 8 | 28859 | 19 | |||
163468 | 119743 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
164599 | 51670 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 848 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47948 | 5998713.82301338 | 2107188.47532501 | 37.765863591183 | -122.447690414133 | (37.765863591183, -122.447690414133) | 15 | 5 | 11 | 29492 | 9 | ||||
164683 | 112815 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10 LOMITA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991472 | 2104830 | 37.7589712942358 | -122.472566156736 | (37.7589712942358, -122.472566156736) | 1 | 8 | 4 | 56 | 12 | ||||
172953 | 34010 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 123 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1997 12:00:00 AM | Permit Number 37945 | 6002886.66979468 | 2107551.69377695 | 37.7670985064042 | -122.433283380019 | (37.7670985064042, -122.433283380019) | 15 | 5 | 5 | 28862 | 3 | |||
173505 | 119746 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
177869 | 33711 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 109 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | Permit Number 37779 | 6003691.57039211 | 2108804.29883955 | 37.7705834843276 | -122.430588742236 | (37.7705834843276, -122.430588742236) | 15 | 9 | 11 | 29492 | 10 | |||
185043 | 48532 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 500(REVISED) Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45857 | 6007225.9541014 | 2104383.62172477 | 37.7586449307205 | -122.41804980128 | (37.7586449307205, -122.41804980128) | 2 | 4 | 7 | 28859 | 19 | |||
194245 | 106032 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014366.74772 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | 12 | 2 | 9 | 28855 | 6 | ||||
16420 | 189843 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017155.58292 | 2098191.33075 | 37.742196046505 | -122.383277260246 | (37.742196046505, -122.383277260246) | 10 | 3 | 8 | 58 | 1 | |||
17663 | 101489 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 59X Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769087 | 6005416.7 | 2109221 | 37.7718252244657 | -122.424651142233 | (37.7718252244657, -122.424651142233) | 7 | 9 | 5 | 28852 | 10 | |
61480 | 246510 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 231 Duncan St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6004993.26159 | 2099869.66747 | 37.7461247456624 | -122.425450235552 | (37.7461247456624, -122.425450235552) | 2 | 7 | 5 | 63 | 22 | |||
72504 | 225095 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 231 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004583.37564 | 2109107.4182 | 37.7714662577942 | -122.427525575841 | (37.7714662577942, -122.427525575841) | 7 | 9 | 11 | 28852 | 10 | |||
80577 | 189839 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6017074.26086 | 2098217.41845 | 37.7422631836031 | -122.383560265197 | (37.7422631836031, -122.383560265197) | 10 | 3 | 8 | 58 | 1 | |||
98742 | 189846 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017214.17115 | 2098166.7194 | 37.7421317063069 | -122.383072965771 | (37.7421317063069, -122.383072965771) | 10 | 3 | 8 | 58 | 1 | |||
100985 | 189841 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6017113.18863 | 2098207.21128 | 37.7422373082953 | -122.383424953219 | (37.7422373082953, -122.383424953219) | 10 | 3 | 8 | 58 | 1 | |||
166358 | 189847 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017231.39271 | 2098158.22234 | 37.7421093266962 | -122.383012827183 | (37.7421093266962, -122.383012827183) | 10 | 3 | 8 | 58 | 1 | |||
16205 | 222929 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 979 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1979 12:00:00 AM | 10 | Width 4ft | Permit Number 17592 | 5999199.8898 | 2106672.6396 | 37.7644750037296 | -122.445972112616 | (37.7644750037296, -122.445972112616) | 15 | 5 | 11 | 29492 | 9 | |
23100 | 125989 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008326.45195 | 2121634.40634 | 37.8060733149832 | -122.41546506288 | (37.8060733149832, -122.41546506288) | 5 | 1 | 10 | 308 | 23 | |||
25898 | 225060 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 243 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997087.67897 | 2106671.87912 | 37.7643520771977 | -122.453277577199 | (37.7643520771977, -122.453277577199) | 15 | 5 | 11 | 29492 | 12 | |||
32911 | 248271 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 157 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006700.68835 | 2098666.52237 | 37.7429175024299 | -122.419460818167 | (37.7429175024299, -122.419460818167) | 2 | 7 | 7 | 28859 | 2 | |||
35660 | 115844 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003543.04696 | 2120740.86009 | 37.8033498494719 | -122.43195496357 | (37.8033498494719, -122.43195496357) | 13 | 9 | 1 | 57 | 17 | |||
39895 | 189881 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 6 | : | Tree | Private 2 | 10 | Width 3ft | 6016559.49898 | 2098322.63372 | 37.7425236182725 | -122.385347500499 | (37.7425236182725, -122.385347500499) | 10 | 3 | 8 | 58 | 1 | |||
40377 | 103339 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 590X 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6010323 | 2108639 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | 8 | 2 | 9 | 28853 | 34 | |||
45877 | 248276 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 137 Lundy's Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006755.61156 | 2098766.6947 | 37.7431956465585 | -122.419278012984 | (37.7431956465585, -122.419278012984) | 2 | 7 | 7 | 28859 | 2 | |||
47090 | 222910 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6004846.32395 | 2109834.20253 | 37.7734767003282 | -122.426667787188 | (37.7734767003282, -122.426667787188) | 7 | 9 | 11 | 28852 | 10 | |||
48025 | 248201 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 53 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006949.2101 | 2099121.02775 | 37.7441794671077 | -122.418633720666 | (37.7441794671077, -122.418633720666) | 2 | 7 | 7 | 28859 | 2 | |||
64093 | 21787 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2585 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4X4 | 6008331.30284 | 2121636.25204 | 37.8060786554609 | -122.415448406282 | (37.8060786554609, -122.415448406282) | 5 | 1 | 10 | 308 | 23 | |||
64807 | 248261 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 136 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006731.57977 | 2098768.277 | 37.7431986377163 | -122.419361220966 | (37.7431986377163, -122.419361220966) | 2 | 7 | 7 | 28859 | 2 | |||
65527 | 248255 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 116 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006791.47872 | 2098879.96545 | 37.7435086825726 | -122.41916202653 | (37.7435086825726, -122.41916202653) | 2 | 7 | 7 | 28859 | 2 | |||
69120 | 125994 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008347.52133 | 2121476.34798 | 37.8056405108592 | -122.415380951989 | (37.8056405108592, -122.415380951989) | 5 | 1 | 10 | 308 | 23 | |||
72425 | 189898 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 5 | : | Tree | Private 2 | 10 | Width 3ft | 6016641.64949 | 2098357.67933 | 37.7426243909147 | -122.385065886799 | (37.7426243909147, -122.385065886799) | 10 | 3 | 8 | 58 | 1 | |||
75614 | 189900 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 8 | : | Tree | Private 2 | 10 | Width 3ft | 6016469.43957 | 2098386.38148 | 37.7426936737758 | -122.385663344212 | (37.7426936737758, -122.385663344212) | 10 | 3 | 8 | 58 | 1 | |||
83845 | 189890 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 200 Newhall St | 4 | : | Tree | Private 2 | 10 | Width 4ft | 6016847.57568 | 2098318.03852 | 37.742526934071 | -122.384351086743 | (37.742526934071, -122.384351086743) | 10 | 3 | 8 | 58 | 1 | |||
108134 | 103342 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 590X 09th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6010323 | 2108639 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | 8 | 2 | 9 | 28853 | 34 | |||
111174 | 248263 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 140 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006717.3063 | 2098747.87418 | 37.7431418122345 | -122.419409127839 | (37.7431418122345, -122.419409127839) | 2 | 7 | 7 | 28859 | 2 | |||
113408 | 139006 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1504 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5999695.1779 | 2114053.1244 | 37.7847682058679 | -122.444789604899 | (37.7847682058679, -122.444789604899) | 15 | 6 | 1 | 29490 | 31 | |||
116588 | 222905 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6004739.78961 | 2109820.49268 | 37.7734330328342 | -122.427035328438 | (37.7734330328342, -122.427035328438) | 7 | 9 | 11 | 28852 | 10 | |||
117653 | 205999 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 60 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001682.52176 | 2095686.82759 | 37.7344520302196 | -122.436598984369 | (37.7344520302196, -122.436598984369) | 2 | 7 | 5 | 63 | 7 | |||
118207 | 225062 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 139 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5998883.5307 | 2107364.06639 | 37.7663554177878 | -122.447116070946 | (37.7663554177878, -122.447116070946) | 15 | 5 | 11 | 29492 | 9 | |||
129552 | 189854 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 102 Newhall St | 4 | : | Tree | Private 2 | 10 | Width 3ft | 6017283.71117 | 2098187.47887 | 37.7421925499461 | -122.382833960126 | (37.7421925499461, -122.382833960126) | 10 | 3 | 8 | 58 | 1 | |||
136796 | 248230 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 74 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006935.57349 | 2099151.82262 | 37.7442632551522 | -122.418683056597 | (37.7442632551522, -122.418683056597) | 2 | 7 | 7 | 28859 | 2 | |||
143777 | 189858 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 102 Newhall St | 8 | : | Tree | Private 2 | 10 | Width 4ft | 6017192.20681 | 2098235.03839 | 37.7423180827181 | -122.383153666435 | (37.7423180827181, -122.383153666435) | 10 | 3 | 8 | 58 | 1 | |||
144028 | 125988 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008319.39655 | 2121673.00017 | 37.806178887323 | -122.415492213411 | (37.806178887323, -122.415492213411) | 5 | 1 | 10 | 308 | 23 | |||
149944 | 248228 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 70 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006955.04848 | 2099184.3603 | 37.744353692776 | -122.418618023005 | (37.744353692776, -122.418618023005) | 2 | 7 | 7 | 28859 | 2 | |||
153118 | 189887 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 200 Newhall St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6016910.34518 | 2098303.24769 | 37.7424897920671 | -122.384133016442 | (37.7424897920671, -122.384133016442) | 10 | 3 | 8 | 58 | 1 |
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) );