Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32711 | 32711 | 124322 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 115 Jordan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5996192.87314 | 2113669.7360400003 | 37.7835150337529 | -122.456878613619 | (37.7835150337529, -122.456878613619) | |||
51566 | 51566 | 124321 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 115 Jordan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5996193.40211 | 2113658.2283900003 | 37.783483467186706 | -122.45687595100901 | (37.7834834671867, -122.456875951009) | |||
26990 | 26990 | 222896 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 115 Julian Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6006441.81181 | 2107164.43854 | 37.76623623692421 | -122.420959163358 | (37.7662362369242, -122.420959163358) | |||
93830 | 93830 | 63116 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 115 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1986 12:00:00 AM | Permit Number 23622 | 6006844.85682717 | 2098899.69149034 | 37.7435658517454 | -122.41897885676701 | (37.7435658517454, -122.418978856767) | ||
156357 | 156357 | 248255 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 116 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006791.47872 | 2098879.96545 | 37.7435086825726 | -122.41916202653 | (37.7435086825726, -122.41916202653) | |||
127787 | 127787 | 58566 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 119 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/16/1979 12:00:00 AM | 3x3 | Permit Number 17756 | 5997901.33257876 | 2107130.89979942 | 37.7656590338964 | -122.450496484092 | (37.7656590338964, -122.450496484092) | ||
55327 | 55327 | 189949 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6014767.16396 | 2116087.91405 | 37.791203859513004 | -122.392787475772 | (37.791203859513, -122.392787475772) | |||
75800 | 75800 | 189950 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6014741.1957 | 2116062.8749700002 | 37.79113366564629 | -122.392875573361 | (37.7911336656463, -122.392875573361) | |||
96732 | 96732 | 189953 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6014700.62775 | 2116023.46282 | 37.7910231956157 | -122.39301317951201 | (37.7910231956157, -122.393013179512) | |||
150575 | 150575 | 56925 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1974 12:00:00 AM | 12 | Permit Number 14168 | 6014784.53223 | 2116103.90747 | 37.7912487383869 | -122.392728500917 | (37.7912487383869, -122.392728500917) | ||
161429 | 161429 | 189951 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 6014728.34644 | 2116051.81938 | 37.791102595846894 | -122.39291925791099 | (37.7911025958469, -122.392919257911) | |||
163641 | 163641 | 96473 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | Permit Number 767637 | 6014754.27658 | 2116074.97331 | 37.7911676114441 | -122.392831160352 | (37.7911676114441, -122.392831160352) | ||
179956 | 179956 | 189952 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 1ft | 6014715.63981 | 2116037.4080000003 | 37.7910623197318 | -122.392962214036 | (37.7910623197318, -122.392962214036) | |||
122387 | 122387 | 65950 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 120 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | Permit Number 28971 | 6008148.07854497 | 2112823.994523 | 37.7818720705068 | -122.415458212735 | (37.7818720705068, -122.415458212735) | ||
66722 | 66722 | 248258 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006769.1868199995 | 2098841.93634 | 37.7434030077589 | -122.41923640944201 | (37.7434030077589, -122.419236409442) | |||
179238 | 179238 | 248257 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006778.60351 | 2098856.6294 | 37.7434438819296 | -122.41920489088899 | (37.7434438819296, -122.419204890889) | |||
132092 | 132092 | 206014 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992843.12782 | 2095854.05613 | 37.7344049138512 | -122.467171573123 | (37.7344049138512, -122.467171573123) | |||
25981 | 25981 | 47237 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1200X Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 9 | 3x3 | Permit Number 45189 | 6014656.8506 | 2090563.7281 | 37.721113790544 | -122.391384069594 | (37.721113790544, -122.391384069594) |
122964 | 122964 | 47238 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1200X Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45189 | 6014641.0147 | 2090577.1277 | 37.7211497042731 | -122.39143974641 | (37.7211497042731, -122.39143974641) |
53992 | 53992 | 222919 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 121 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997880.24105 | 2107132.61559 | 37.765662537824895 | -122.45056955843701 | (37.7656625378249, -122.450569558437) | |||
140440 | 140440 | 34010 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 123 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1997 12:00:00 AM | Permit Number 37945 | 6002886.66979468 | 2107551.69377695 | 37.7670985064042 | -122.43328338001899 | (37.7670985064042, -122.433283380019) | |||
101649 | 101649 | 62273 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 123 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1985 12:00:00 AM | Permit Number 22409 | 6004226.44756002 | 2109195.3304156 | 37.7716874486567 | -122.42876647673701 | (37.7716874486567, -122.428766476737) | ||
174407 | 174407 | 222887 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 123 Webster St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6004226.51196 | 2109212.81898 | 37.77173547164 | -122.42876750091801 | (37.77173547164, -122.428767500918) | |||
129912 | 129912 | 225061 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1289 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 5997502.5049 | 2105021.0962900002 | 37.7598432128005 | -122.451723726786 | (37.7598432128005, -122.451723726786) | |||
54347 | 54347 | 206013 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 130 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5992845.13508 | 2095810.8192900002 | 37.7342863121439 | -122.467161490835 | (37.7342863121439, -122.467161490835) | |||
177476 | 177476 | 32581 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1314 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 4 | Permit Number 37055 | 5985876.1437 | 2106257.7648 | 37.762566049362704 | -122.492024105228 | (37.7625660493627, -122.492024105228) | |
165360 | 165360 | 248260 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 132 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006738.11061 | 2098784.48151 | 37.7432434994904 | -122.419339788302 | (37.7432434994904, -122.419339788302) | |||
39562 | 39562 | 199697 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1331 Thomas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6016182.8401 | 2092843.0517 | 37.7274569422187 | -122.386267947878 | (37.7274569422187, -122.386267947878) | |||
174686 | 174686 | 199696 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1337 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6016147.0349 | 2092868.9416 | 37.7275260488519 | -122.386393532075 | (37.7275260488519, -122.386393532075) | |||
68963 | 68963 | 199693 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1341 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6016099.1110000005 | 2092907.501 | 37.7276292724139 | -122.386561894416 | (37.7276292724139, -122.386561894416) | |||
37989 | 37989 | 199692 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1343 Thomas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016085.8906 | 2092920.1706 | 37.7276633287451 | -122.386608480998 | (37.7276633287451, -122.386608480998) | |||
62337 | 62337 | 199691 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1343 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016071.0177 | 2092930.0859 | 37.7276897308085 | -122.38666058841001 | (37.7276897308085, -122.38666058841) | |||
17478 | 17478 | 5658 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1349-1349 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6005239.88286 | 2100530.07402 | 37.74795200168529 | -122.42464442051 | (37.7479520016853, -122.42464442051) | |||
45389 | 45389 | 248262 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 136 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6006723.28629 | 2098755.01317 | 37.743161751109 | -122.41938895693 | (37.743161751109, -122.41938895693) | |||
104259 | 104259 | 248261 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 136 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006731.57977 | 2098768.277 | 37.7431986377163 | -122.419361220966 | (37.7431986377163, -122.419361220966) | |||
19409 | 19409 | 16623 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 136 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002840.1476308 | 2107468.9628395 | 37.7668687081336 | -122.433438380285 | (37.7668687081336, -122.433438380285) | |||
46452 | 46452 | 248275 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 137 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006752.53211 | 2098758.7700799997 | 37.743173713897 | -122.41928809889299 | (37.743173713897, -122.419288098893) | |||
135232 | 135232 | 248274 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 137 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006747.61558 | 2098750.1570099997 | 37.743149787441 | -122.419304488116 | (37.743149787441, -122.419304488116) | |||
183547 | 183547 | 248276 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 137 Lundy's Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006755.61156 | 2098766.6947 | 37.7431956465585 | -122.41927801298401 | (37.7431956465585, -122.419278012984) | |||
23084 | 23084 | 16626 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 138 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2001 12:00:00 AM | 21 | 3X3 | 6002836.08721 | 2107485.6498 | 37.7669142960875 | -122.43345361721 | (37.7669142960875, -122.43345361721) | ||
163059 | 163059 | 225062 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 139 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5998883.5307 | 2107364.0663900003 | 37.76635541778779 | -122.44711607094601 | (37.7663554177878, -122.447116070946) | |||
182071 | 182071 | 222886 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 139 Webster St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6004216.91806 | 2109283.17336 | 37.7719281046318 | -122.428805703247 | (37.7719281046318, -122.428805703247) | |||
142096 | 142096 | 10409 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1398 HAIGHT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 5999436.0 | 2108778.0 | 37.7702692735678 | -122.445306860847 | (37.7702692735678, -122.445306860847) | |||
135516 | 135516 | 247504 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1398 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5999483.6766 | 2108789.6708 | 37.7703040400286 | -122.44514278745399 | (37.7703040400286, -122.445142787454) | |||
31832 | 31832 | 222918 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5997702.832359999 | 2107152.93734 | 37.7657081802151 | -122.451184638974 | (37.7657081802151, -122.451184638974) | |||
100270 | 100270 | 54886 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 140 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1972 12:00:00 AM | 3x4 | Permit Number 10751 | 5997750.13061777 | 2107162.33224107 | 37.7657366841835 | -122.45102172287201 | (37.7657366841835, -122.451021722872) | ||
61155 | 61155 | 111886 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x12 | 6006709.0 | 2098750.0 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | |||
104253 | 104253 | 111888 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 LUNDYS LN | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x12 | 6006709.0 | 2098750.0 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | ||||
126258 | 126258 | 111887 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 LUNDYS LN | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x12 | 6006709.0 | 2098750.0 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | |||
50402 | 50402 | 248264 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006711.60121 | 2098736.3727599997 | 37.743109910586 | -122.419428038785 | (37.743109910586, -122.419428038785) | |||
68659 | 68659 | 248263 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006717.3063 | 2098747.87418 | 37.743141812234505 | -122.41940912783899 | (37.7431418122345, -122.419409127839) | |||
78262 | 78262 | 62275 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 141 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1985 12:00:00 AM | Permit Number 22411 | 6004215.98521889 | 2109270.59348358 | 37.771893510559 | -122.428808033039 | (37.771893510559, -122.428808033039) | ||
154115 | 154115 | 32473 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 144 Lower Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 9 | Permit Number 36981 | 6000263.910540001 | 2106227.11632 | 37.763312407875205 | -122.442259981907 | (37.7633124078752, -122.442259981907) | |
59090 | 59090 | 189955 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 145 Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6014561.092019999 | 2115949.59191 | 37.790812611275 | -122.39349079958299 | (37.790812611275, -122.393490799583) | |||
169467 | 169467 | 189954 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 145 Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6014570.20304 | 2115942.2831 | 37.7907930492013 | -122.393458763924 | (37.7907930492013, -122.393458763924) | |||
82964 | 82964 | 13332 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 145 Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6011384.17484 | 2090567.17856 | 37.7209410845847 | -122.402697063866 | (37.7209410845847, -122.402697063866) | |||
119338 | 119338 | 113383 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 146 CASTENADA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 5994461.0 | 2101055.0 | 37.7487786662853 | -122.46195512222401 | (37.7487786662853, -122.461955122224) | |||
34571 | 34571 | 206020 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 146 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994480.54768 | 2101060.81011 | 37.7487957447457 | -122.46188794817499 | (37.7487957447457, -122.461887948175) | |||
168692 | 168692 | 205988 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1469 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5993333.43827 | 2105504.18267 | 37.7609299931406 | -122.46617747513099 | (37.7609299931406, -122.466177475131) | |||
72501 | 72501 | 225044 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 15 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007468.43971 | 2099454.94472 | 37.7451255476034 | -122.4168619861 | (37.7451255476034, -122.4168619861) | |||
145872 | 145872 | 63270 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 15 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | Permit Number 23827 | 6007494.42657363 | 2099465.13084364 | 37.7451549781049 | -122.41677284932 | (37.7451549781049, -122.41677284932) | ||
32206 | 32206 | 115845 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6003527.72894 | 2120738.7231400004 | 37.8033431135653 | -122.432007819421 | (37.8033431135653, -122.432007819421) | |||
42092 | 42092 | 115843 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6003556.384769999 | 2120742.54729 | 37.80335523820229 | -122.431908928161 | (37.8033552382023, -122.431908928161) | |||
46321 | 46321 | 115844 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6003543.04696 | 2120740.86009 | 37.8033498494719 | -122.43195496357 | (37.8033498494719, -122.43195496357) | |||
135731 | 135731 | 115846 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003504.2747 | 2120736.26354 | 37.8033350304463 | -122.432088807873 | (37.8033350304463, -122.432088807873) | |||
174264 | 174264 | 115842 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6003573.215530001 | 2120746.37029 | 37.8033666892713 | -122.431850957862 | (37.8033666892713, -122.431850957862) | |||
14244 | 14244 | 2501 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016709.08958 | 2098828.16093 | 37.7439199677279 | -122.38486546568599 | (37.7439199677279, -122.384865465686) | |||
15570 | 15570 | 2499 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016750.97009 | 2098814.51662 | 37.7438848195436 | -122.384719700863 | (37.7438848195436, -122.384719700863) | |||
15689 | 15689 | 2500 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016728.12134 | 2098825.14197 | 37.7439127309012 | -122.384799447345 | (37.7439127309012, -122.384799447345) | |||
15763 | 15763 | 2504 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016654.18712 | 2098861.64491 | 37.7440088711085 | -122.385057640012 | (37.7440088711085, -122.385057640012) | |||
16423 | 16423 | 2503 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016672.43224 | 2098847.72364 | 37.743971655361705 | -122.384993582204 | (37.7439716553617, -122.384993582204) | |||
16723 | 16723 | 2498 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016761.82696 | 2098799.8032400003 | 37.7438450200413 | -122.384681135251 | (37.7438450200413, -122.384681135251) | |||
16898 | 16898 | 2502 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016691.633780001 | 2098834.3481 | 37.743935990943996 | -122.38492625536001 | (37.743935990944, -122.38492625536) | |||
43464 | 43464 | 206016 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995893.6658 | 2094152.61505 | 37.7299087874515 | -122.45650193453899 | (37.7299087874515, -122.456501934539) | |||
89436 | 89436 | 110184 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500x LYON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999718.0 | 2114083.0 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | ||||
95567 | 95567 | 110183 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500x LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999718.0 | 2114083.0 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | ||||
97353 | 97353 | 110185 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500x LYON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999718.0 | 2114083.0 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | ||||
82357 | 82357 | 2507 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1501 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067003 | 37.743747386445996 | -122.384952066789 | (37.743747386446, -122.384952066789) | |||
100205 | 100205 | 2512 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1501 Burke Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067003 | 37.743747386445996 | -122.384952066789 | (37.743747386446, -122.384952066789) | |||
110164 | 110164 | 2510 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1501 Burke Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067003 | 37.743747386445996 | -122.384952066789 | (37.743747386446, -122.384952066789) | |||
127149 | 127149 | 2509 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1501 Burke Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016682.7889975 | 2098765.8378067003 | 37.743747386445996 | -122.384952066789 | (37.743747386446, -122.384952066789) | |||
140142 | 140142 | 2505 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1501 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067003 | 37.743747386445996 | -122.384952066789 | (37.743747386446, -122.384952066789) | |||
145072 | 145072 | 2511 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1501 Burke Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067003 | 37.743747386445996 | -122.384952066789 | (37.743747386446, -122.384952066789) | |||
38805 | 38805 | 139008 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1504 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5999687.2486 | 2114098.7181 | 37.7848929418184 | -122.444820316061 | (37.7848929418184, -122.444820316061) | |||
134055 | 134055 | 139006 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1504 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999695.1779 | 2114053.1244 | 37.7847682058679 | -122.444789604899 | (37.7847682058679, -122.444789604899) | |||
175276 | 175276 | 139007 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1504 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5999691.7088 | 2114071.461 | 37.78481835543629 | -122.444802925313 | (37.7848183554363, -122.444802925313) | |||
25551 | 25551 | 138242 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1509 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999647.1063 | 2114070.9654 | 37.7848144491807 | -122.444957199215 | (37.7848144491807, -122.444957199215) | |||
47133 | 47133 | 138241 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1509 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999646.1152 | 2114082.8594 | 37.784847050450104 | -122.444961483404 | (37.7848470504501, -122.444961483404) | |||
53751 | 53751 | 138243 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1509 Lyon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5999648.5931 | 2114056.0979 | 37.7847737117432 | -122.44495098624701 | (37.7847737117432, -122.444950986247) | |||
65381 | 65381 | 138240 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1509 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999643.6372 | 2114098.2225 | 37.7848890921049 | -122.444971161243 | (37.7848890921049, -122.444971161243) | |||
65703 | 65703 | 138239 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1509 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999639.177 | 2114119.037 | 37.784945988756 | -122.444988088871 | (37.784945988756, -122.444988088871) | |||
39980 | 39980 | 30908 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1511 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | 7 | Permit Number 34730 | 5999634.2212 | 2114153.2322 | 37.7850395970423 | -122.44500769339199 | (37.7850395970423, -122.445007693392) | ||
40687 | 40687 | 57316 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1515 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/1976 12:00:00 AM | 13 | Permit Number 16140 | 5999629.2653 | 2114178.0114 | 37.7851073514303 | -122.445026621162 | (37.7851073514303, -122.445026621162) | ||
43136 | 43136 | 188487 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1525 Burke Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6016679.39003 | 2098723.9070200003 | 37.74363206505979 | -122.384960899022 | (37.7436320650598, -122.384960899022) | |||
53695 | 53695 | 188483 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1525 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6016580.588769999 | 2098830.3730200003 | 37.7439189335051 | -122.38530995020399 | (37.7439189335051, -122.385309950204) | |||
54211 | 54211 | 188484 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1525 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6016633.990259999 | 2098788.07165 | 37.743805736753394 | -122.38512235163 | (37.7438057367534, -122.38512235163) | |||
134310 | 134310 | 188488 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1525 Burke Ave | 8 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6016697.4652 | 2098710.93051 | 37.743597433976205 | -122.38489749504299 | (37.7435974339762, -122.384897495043) | |||
156358 | 156358 | 188485 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1525 Burke Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6016660.6215 | 2098754.7402 | 37.7437156885266 | -122.385027944407 | (37.7437156885266, -122.385027944407) | |||
179366 | 179366 | 188486 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1525 Burke Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6016667.7961 | 2098739.5766 | 37.7436744492327 | -122.385002079878 | (37.7436744492327, -122.385002079878) | |||
63634 | 63634 | 182440 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1530 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5985926.0511 | 2104791.6519 | 37.7585434265078 | -122.49174356193998 | (37.7585434265078, -122.49174356194) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");