trees
752 rows where qSiteInfo = "Sidewalk: Curb side : Cutout" and qSpecies_id = 5 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
75171 | 206004 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 10 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991469.80126 | 2104851.05791 | 37.7590289864229 | -122.472575296214 | (37.7590289864229, -122.472575296214) | 1 | 8 | 4 | 56 | 12 | |||
187721 | 125971 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6008148.4886 | 2112831.14919 | 37.7818917385495 | -122.415457300812 | (37.7818917385495, -122.415457300812) | 7 | 10 | 9 | 28852 | 36 | |||
13041 | 19762 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100 STAIRWAY16 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 30ST | |||||||||||||
12712 | 19967 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100 STAIRWAY41 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
117059 | 222915 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6004287.81752 | 2109130.32918 | 37.7715124442731 | -122.42854956012 | (37.7715124442731, -122.42854956012) | 7 | 9 | 11 | 28852 | 10 | |||
124477 | 189963 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1000 Brannan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6010349.36768 | 2108372.96344 | 37.7697740574441 | -122.40752882731 | (37.7697740574441, -122.40752882731) | 8 | 2 | 9 | 28853 | 34 | |||
155251 | 103345 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 1000 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | Permit Number 29899 | 6010491 | 2108479 | 37.7700731362443 | -122.407046397751 | (37.7700731362443, -122.407046397751) | 8 | 2 | 9 | 28853 | 34 | ||
112435 | 47241 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1000X Jamestown Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45190 | 6014093.2543098 | 2089771.82198012 | 37.718908077116 | -122.393276886105 | (37.718908077116, -122.393276886105) | 10 | 3 | 8 | 58 | 1 |
56518 | 237914 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1001 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 4ft | 5997227 | 2107052 | 37.7654037766697 | -122.452823145368 | (37.7654037766697, -122.452823145368) | 15 | 5 | 11 | 29492 | 12 | |||
138537 | 47239 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1004X Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45190 | 6013984.3411 | 2089670.3406 | 37.7186233778889 | -122.393646260173 | (37.7186233778889, -122.393646260173) | 10 | 3 | 8 | 58 | 1 |
154770 | 47240 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1006X Jamestown Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45190 | 6013969.3769 | 2089681.5637 | 37.7186533627648 | -122.393698770823 | (37.7186533627648, -122.393698770823) | 10 | 3 | 8 | 58 | 1 |
109482 | 200192 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1008 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6013935.7075 | 2089708.6863 | 37.718725965018 | -122.393817050636 | (37.718725965018, -122.393817050636) | 10 | 3 | 8 | 58 | 1 | |||
12701 | 3581 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
34794 | 83038 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/04/2006 12:00:00 AM | 6018593.33009 | 2097780.6594 | 37.7411477742489 | -122.378277419086 | (37.7411477742489, -122.378277419086) | 10 | 3 | 8 | 58 | 1 | |||
42308 | 3639 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 75 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017551.66161 | 2098562.89956 | 37.743238180002 | -122.381933568796 | (37.743238180002, -122.381933568796) | 10 | 3 | 8 | 58 | 1 | ||
46225 | 3611 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 47 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6018038.29611 | 2098194.83807 | 37.7422544187983 | -122.380225323637 | (37.7422544187983, -122.380225323637) | 10 | 3 | 8 | 58 | 1 | ||
100284 | 3652 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 88 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017348.88964 | 2098746.4497 | 37.7437309716031 | -122.382647477613 | (37.7437309716031, -122.382647477613) | 10 | 3 | 8 | 58 | 1 | ||
101145 | 3593 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 29 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/06/2016 12:00:00 AM | 7 | 3X3 | 6018341.35218 | 2097966.95491 | 37.7416454132021 | -122.379161613636 | (37.7416454132021, -122.379161613636) | 10 | 3 | 8 | 58 | 1 | ||
163469 | 3627 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 63 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/06/2016 12:00:00 AM | 3 | 3X3 | 6017747.14415 | 2098409.63099 | 37.7428281287262 | -122.381246979566 | (37.7428281287262, -122.381246979566) | 10 | 3 | 8 | 58 | 1 | ||
169962 | 83036 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/18/2017 02:55:00 PM | 3 | 6018559.56213 | 2097806.04485 | 37.7412156164156 | -122.378395939846 | (37.7412156164156, -122.378395939846) | 10 | 3 | 8 | 58 | 1 | |||
120772 | 51301 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 101 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/20/2004 12:00:00 AM | Permit Number 47670 | 6008105.70875607 | 2112751.56982087 | 37.7816708281319 | -122.415599663608 | (37.7816708281319, -122.415599663608) | 7 | 10 | 9 | 28852 | 36 | ||
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 | |||
64200 | 189844 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017173.06513 | 2098183.08322 | 37.7421743665616 | -122.383216237654 | (37.7421743665616, -122.383216237654) | 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 | |||
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 | |||
112903 | 62270 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 102 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1985 12:00:00 AM | Permit Number 22404 | 6004290.78316217 | 2109110.18870614 | 37.7714573112605 | -122.42853786595 | (37.7714573112605, -122.42853786595) | 7 | 9 | 11 | 28852 | 10 | ||
16559 | 222925 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1025 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998825.08997 | 2106348.09575 | 37.7635624787486 | -122.447245077795 | (37.7635624787486, -122.447245077795) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
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 | ||||
110010 | 222924 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1025 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998822.08068 | 2106365.67219 | 37.763610567293 | -122.447256751019 | (37.763610567293, -122.447256751019) | 15 | 5 | 11 | 29492 | 9 | |||
61840 | 222914 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 108 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6004276.58953 | 2109191.75922 | 37.7716804808011 | -122.428592777936 | (37.7716804808011, -122.428592777936) | 7 | 9 | 11 | 28852 | 10 | |||
62864 | 62271 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 108 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1985 12:00:00 AM | Permit Number 22405 | 6004283.36290773 | 2109163.56782991 | 37.7716034574246 | -122.428567338549 | (37.7716034574246, -122.428567338549) | 7 | 9 | 11 | 28852 | 10 | ||
29498 | 225099 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 109 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | 14 | Width 3ft | Permit Number 37779 | 6003663.75485 | 2108815.27117 | 37.7706120358534 | -122.430685739554 | (37.7706120358534, -122.430685739554) | 15 | 9 | 11 | 29492 | 10 | |
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 | |||
147007 | 222888 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 109 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6004218 | 2109157 | 37.7715817245566 | -122.428792964354 | (37.7715817245566, -122.428792964354) | 7 | 9 | 11 | 29492 | 10 | |||
68954 | 7418 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1090 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010342.8854 | 2110986.7114 | 37.7769504410171 | -122.407735574616 | (37.7769504410171, -122.407735574616) | 14 | 2 | 9 | 28853 | 34 | |||
99086 | 7417 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1090 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2003 12:00:00 AM | 6 | 3X3 | 6010360.059 | 2111002.9309 | 37.7769959373466 | -122.407677309481 | (37.7769959373466, -122.407677309481) | 14 | 2 | 9 | 28853 | 34 | ||
175440 | 7419 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1090 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6010341.13591 | 2111005.37017 | 37.777001575706 | -122.407742942642 | (37.777001575706, -122.407742942642) | 14 | 2 | 9 | 28853 | 34 | |||
1256 | 97187 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | 12 | 2 | 9 | 28855 | 6 | |||
24818 | 97179 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013408 | 2116114 | 37.7911999015077 | -122.397492006217 | (37.7911999015077, -122.397492006217) | 12 | 2 | 9 | 28855 | 6 | |||
42963 | 97180 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | 12 | 2 | 9 | 28855 | 6 | |||
103825 | 97186 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | 12 | 2 | 9 | 28855 | 6 | |||
110444 | 97188 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | 12 | 2 | 9 | 28855 | 6 | |||
124374 | 97181 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | 12 | 2 | 9 | 28855 | 6 | |||
127764 | 97182 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | 12 | 2 | 9 | 28855 | 6 | |||
128485 | 97184 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013138 | 2116168 | 37.791333135618 | -122.398429995238 | (37.791333135618, -122.398429995238) | 12 | 2 | 9 | 28855 | 6 | |||
157690 | 97185 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | 12 | 2 | 9 | 28855 | 6 | |||
158873 | 97183 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | 12 | 2 | 9 | 28855 | 6 | |||
17541 | 14919 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017351.5544479 | 2098138.8848753 | 37.7420628687633 | -122.382595996286 | (37.7420628687633, -122.382595996286) | 10 | 3 | 8 | 58 | 1 | |||
19610 | 14916 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6017173.30591 | 2098243.55942 | 37.7423404352704 | -122.383219613607 | (37.7423404352704, -122.383219613607) | 10 | 3 | 8 | 58 | 1 | |||
33168 | 14912 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017247.98036 | 2098210.14599 | 37.7422528150795 | -122.38295908457 | (37.7422528150795, -122.38295908457) | 10 | 3 | 8 | 58 | 1 | |||
36755 | 14910 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017317.95316 | 2098168.33206 | 37.7421418684871 | -122.38271422872 | (37.7421418684871, -122.38271422872) | 10 | 3 | 8 | 58 | 1 | |||
43304 | 14908 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017351.5544479 | 2098138.8848753 | 37.7420628687633 | -122.382595996286 | (37.7420628687633, -122.382595996286) | 10 | 3 | 8 | 58 | 1 | |||
49574 | 14913 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017225.13937 | 2098220.80076 | 37.7422808088462 | -122.383038803855 | (37.7422808088462, -122.383038803855) | 10 | 3 | 8 | 58 | 1 | |||
77909 | 14909 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017336.92539 | 2098155.67833 | 37.7421081720326 | -122.382647747732 | (37.7421081720326, -122.382647747732) | 10 | 3 | 8 | 58 | 1 | |||
98289 | 14914 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017206.58246 | 2098230.05631 | 37.7423051973143 | -122.383103612647 | (37.7423051973143, -122.383103612647) | 10 | 3 | 8 | 58 | 1 | |||
108291 | 14920 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017135.89317 | 2098259.62578 | 37.7423824826909 | -122.383350094901 | (37.7423824826909, -122.383350094901) | 10 | 3 | 8 | 58 | 1 | |||
149371 | 14911 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6017284.29114 | 2098190.72199 | 37.7422014869413 | -122.38283218039 | (37.7422014869413, -122.38283218039) | 10 | 3 | 8 | 58 | 1 | |||
166582 | 14918 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017351.5544479 | 2098138.8848753 | 37.7420628687633 | -122.382595996286 | (37.7420628687633, -122.382595996286) | 10 | 3 | 8 | 58 | 1 | |||
180338 | 14917 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017157.89779 | 2098250.45331 | 37.7423585130106 | -122.383273370488 | (37.7423585130106, -122.383273370488) | 10 | 3 | 8 | 58 | 1 | |||
191303 | 14915 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017191.33538 | 2098236.4203 | 37.7423218290085 | -122.383156775767 | (37.7423218290085, -122.383156775767) | 10 | 3 | 8 | 58 | 1 | |||
105802 | 248279 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 111 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006822.34586 | 2098891.67697 | 37.743542578041 | -122.419056125953 | (37.743542578041, -122.419056125953) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||||
174101 | 113692 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 112 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6006814 | 2098928 | 37.7436418429474 | -122.419087559811 | (37.7436418429474, -122.419087559811) | 2 | 7 | 7 | 28859 | 2 | |||
157121 | 248253 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 112 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006804.33159 | 2098902.21261 | 37.7435704920937 | -122.419119162122 | (37.7435704920937, -122.419119162122) | 2 | 7 | 7 | 28859 | 2 | |||
177859 | 248254 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 112 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006798.65634 | 2098892.16282 | 37.7435425780247 | -122.419138073069 | (37.7435425780247, -122.419138073069) | 2 | 7 | 7 | 28859 | 2 | |||
78514 | 222913 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 112 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004271.62218 | 2109232.31503 | 37.771791556066 | -122.428612851729 | (37.771791556066, -122.428612851729) | 7 | 9 | 11 | 28852 | 10 | |||
131347 | 62272 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 113 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1985 12:00:00 AM | Permit Number 22406 | 6004233.40404883 | 2109145.28748516 | 37.7715504366717 | -122.428738845772 | (37.7715504366717, -122.428738845772) | 7 | 9 | 11 | 29492 | 10 | ||
35310 | 47061 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 114 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | 3x3 | Permit Number 45048 | 6004275.94265243 | 2109216.94695979 | 37.7717496035942 | -122.428596811267 | (37.7717496035942, -122.428596811267) | 7 | 9 | 11 | 28852 | 10 | |
151186 | 222896 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 115 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6006441.81181 | 2107164.43854 | 37.7662362369242 | -122.420959163358 | (37.7662362369242, -122.420959163358) | 8 | 4 | 7 | 28853 | 19 | |||
82514 | 63116 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 115 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1986 12:00:00 AM | Permit Number 23622 | 6006844.85682717 | 2098899.69149034 | 37.7435658517454 | -122.418978856767 | (37.7435658517454, -122.418978856767) | 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 | |||
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 | ||
17034 | 96473 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | Permit Number 767637 | 6014754.27658 | 2116074.97331 | 37.7911676114441 | -122.392831160352 | (37.7911676114441, -122.392831160352) | 12 | 2 | 9 | 28855 | 6 | ||
104489 | 189953 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014700.62775 | 2116023.46282 | 37.7910231956157 | -122.393013179512 | (37.7910231956157, -122.393013179512) | 12 | 2 | 9 | 28855 | 6 | |||
107370 | 189952 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 6014715.63981 | 2116037.408 | 37.7910623197318 | -122.392962214036 | (37.7910623197318, -122.392962214036) | 12 | 2 | 9 | 28855 | 6 | |||
112676 | 189950 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6014741.1957 | 2116062.87497 | 37.7911336656463 | -122.392875573361 | (37.7911336656463, -122.392875573361) | 12 | 2 | 9 | 28855 | 6 | |||
113987 | 189951 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 6014728.34644 | 2116051.81938 | 37.7911025958469 | -122.392919257911 | (37.7911025958469, -122.392919257911) | 12 | 2 | 9 | 28855 | 6 | |||
123100 | 56925 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 12 | Permit Number 14168 | 6014784.53223 | 2116103.90747 | 37.7912487383869 | -122.392728500917 | (37.7912487383869, -122.392728500917) | 12 | 2 | 9 | 28855 | 6 | ||
177137 | 189949 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6014767.16396 | 2116087.91405 | 37.791203859513 | -122.392787475772 | (37.791203859513, -122.392787475772) | 12 | 2 | 9 | 28855 | 6 | |||
166428 | 65950 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 120 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | Permit Number 28971 | 6008148.07854497 | 2112823.994523 | 37.7818720705068 | -122.415458212735 | (37.7818720705068, -122.415458212735) | 7 | 10 | 9 | 28852 | 36 | ||
75130 | 248258 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006769.18682 | 2098841.93634 | 37.7434030077589 | -122.419236409442 | (37.7434030077589, -122.419236409442) | 2 | 7 | 7 | 28859 | 2 | |||
191608 | 248257 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006778.60351 | 2098856.6294 | 37.7434438819296 | -122.419204890889 | (37.7434438819296, -122.419204890889) | 2 | 7 | 7 | 28859 | 2 | |||
24361 | 206014 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992843.12782 | 2095854.05613 | 37.7344049138512 | -122.467171573123 | (37.7344049138512, -122.467171573123) | 9 | 8 | 4 | 59 | 40 | |||
107061 | 47237 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1200X Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 9 | 3x3 | Permit Number 45189 | 6014656.8506 | 2090563.7281 | 37.721113790544 | -122.391384069594 | (37.721113790544, -122.391384069594) | 10 | 3 | 8 | 58 | 1 |
133710 | 222919 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 121 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997880.24105 | 2107132.61559 | 37.7656625378249 | -122.450569558437 | (37.7656625378249, -122.450569558437) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
102569 | 62273 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 123 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1985 12:00:00 AM | Permit Number 22409 | 6004226.44756002 | 2109195.3304156 | 37.7716874486567 | -122.428766476737 | (37.7716874486567, -122.428766476737) | 7 | 9 | 11 | 29492 | 10 | ||
111120 | 225061 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1289 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 5997502.5049 | 2105021.09629 | 37.7598432128005 | -122.451723726786 | (37.7598432128005, -122.451723726786) | 15 | 5 | 11 | 29492 | 12 | |||
67228 | 206013 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 130 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5992845.13508 | 2095810.81929 | 37.7342863121439 | -122.467161490835 | (37.7342863121439, -122.467161490835) | 9 | 8 | 4 | 59 | 40 | |||
142864 | 32581 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1314 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 4 | Permit Number 37055 | 5985876.1437 | 2106257.7648 | 37.7625660493627 | -122.492024105228 | (37.7625660493627, -122.492024105228) | 1 | 8 | 3 | 56 | 35 | |
53125 | 248260 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 132 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006738.11061 | 2098784.48151 | 37.7432434994904 | -122.419339788302 | (37.7432434994904, -122.419339788302) | 2 | 7 | 7 | 28859 | 2 | |||
100972 | 199697 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1331 Thomas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6016182.8401 | 2092843.0517 | 37.7274569422187 | -122.386267947878 | (37.7274569422187, -122.386267947878) | 10 | 3 | 8 | 58 | 1 | |||
66893 | 199696 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1337 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6016147.0349 | 2092868.9416 | 37.7275260488519 | -122.386393532075 | (37.7275260488519, -122.386393532075) | 10 | 3 | 8 | 58 | 1 | |||
118594 | 199693 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1341 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016099.111 | 2092907.501 | 37.7276292724139 | -122.386561894416 | (37.7276292724139, -122.386561894416) | 10 | 3 | 8 | 58 | 1 | |||
42288 | 199691 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1343 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016071.0177 | 2092930.0859 | 37.7276897308085 | -122.38666058841 | (37.7276897308085, -122.38666058841) | 10 | 3 | 8 | 58 | 1 | |||
170432 | 199692 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1343 Thomas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016085.8906 | 2092920.1706 | 37.7276633287451 | -122.386608480998 | (37.7276633287451, -122.386608480998) | 10 | 3 | 8 | 58 | 1 | |||
32130 | 5658 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1349-1349 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6005239.88286 | 2100530.07402 | 37.7479520016853 | -122.42464442051 | (37.7479520016853, -122.42464442051) | 2 | 4 | 5 | 28859 | 19 | |||
59723 | 248262 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 136 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6006723.28629 | 2098755.01317 | 37.743161751109 | -122.41938895693 | (37.743161751109, -122.41938895693) | 2 | 7 | 7 | 28859 | 2 |
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) );