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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
57958 | 57958 | 183317 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1209 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5983329.0993 | 2106834.4338 | 37.7640002060456 | -122.50087591440399 | (37.7640002060456, -122.500875914404) | |||
173302 | 173302 | 183679 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 3627 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5984438.7811 | 2106305.4338 | 37.7626128114068 | -122.49699886391899 | (37.7626128114068, -122.496998863919) | |||
55179 | 55179 | 184366 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2295 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5987606.9921 | 2099709.6419 | 37.7446876937291 | -122.485557233352 | (37.7446876937291, -122.485557233352) | |||
25343 | 25343 | 183040 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2562 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5989885.4338 | 2097934.2198 | 37.739945333152 | -122.477549168466 | (37.739945333152, -122.477549168466) | |||
137065 | 137065 | 182595 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 955 Rivera St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5990177.9035 | 2100379.6188 | 37.746676731738894 | -122.4767165565 | (37.7466767317389, -122.4767165565) | |||
42406 | 42406 | 182596 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 945 Rivera St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5990197.9307 | 2100380.5725 | 37.746680511997496 | -122.47664737488998 | (37.7466805119975, -122.47664737489) | |||
50270 | 50270 | 206508 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5990927.20691 | 2104481.04629 | 37.7579816107755 | -122.474424823051 | (37.7579816107755, -122.474424823051) | |||
153105 | 153105 | 206509 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5990938.9472 | 2104480.79856 | 37.75798161076639 | -122.47438420248501 | (37.7579816107664, -122.474384202485) | |||
55765 | 55765 | 206510 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5990951.63934 | 2104480.53076 | 37.757981610781606 | -122.474340288587 | (37.7579816107816, -122.474340288587) | |||
160435 | 160435 | 206511 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5990966.24876 | 2104480.85465 | 37.757983346478795 | -122.474289787164 | (37.7579833464788, -122.474289787164) | |||
36423 | 36423 | 206512 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5990980.22345 | 2104481.19226 | 37.7579850830548 | -122.47424148188401 | (37.7579850830548, -122.474241481884) | |||
119103 | 119103 | 206513 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5990992.34085 | 2104483.78156 | 37.757992894562 | -122.47419976413 | (37.757992894562, -122.47419976413) | |||
171944 | 171944 | 206514 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5991006.3222 | 2104484.4348 | 37.7579954981234 | -122.47415145883801 | (37.7579954981234, -122.474151458838) | |||
176247 | 176247 | 206515 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1019 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5991033.61709 | 2104484.17502 | 37.7579963659675 | -122.47405704351601 | (37.7579963659675, -122.474057043516) | |||
153437 | 153437 | 206522 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2204 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991046.63721 | 2100321.91518 | 37.7465686447317 | -122.47370838535801 | (37.7465686447317, -122.473708385358) | |||
171652 | 171652 | 206516 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1019 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991047.261080001 | 2104483.88717 | 37.7579963659448 | -122.474009836278 | (37.7579963659448, -122.474009836278) | |||
181904 | 181904 | 206517 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1019 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5991060.290580001 | 2104484.56084 | 37.7579989703891 | -122.473964824336 | (37.7579989703891, -122.473964824336) | |||
126746 | 126746 | 206518 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1019 Lawton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5991072.98938 | 2104484.60902 | 37.7579998382313 | -122.473920910448 | (37.7579998382313, -122.473920910448) | |||
75714 | 75714 | 206568 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2515 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991380.56657 | 2098286.2467799997 | 37.7409985569439 | -122.472405327055 | (37.7409985569439, -122.472405327055) | |||
185359 | 185359 | 206567 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2523 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991381.7608900005 | 2098233.80223 | 37.74085462674589 | -122.472397375252 | (37.7408546267459, -122.472397375252) | |||
62392 | 62392 | 206521 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2290 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991723.002619999 | 2099864.63418 | 37.7453522181485 | -122.471336295754 | (37.7453522181485, -122.471336295754) | |||
66610 | 66610 | 206520 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2290 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991725.72943 | 2099875.90905 | 37.7453833337792 | -122.47132768833099 | (37.7453833337792, -122.471327688331) | |||
51810 | 51810 | 206519 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2280 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991734.05463 | 2099933.45812 | 37.7455418303067 | -122.471303093689 | (37.7455418303067, -122.471303093689) | |||
75089 | 75089 | 206565 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2679 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991740.0000599995 | 2097213.7223099996 | 37.7380744742606 | -122.471084432514 | (37.7380744742606, -122.471084432514) | |||
186945 | 186945 | 206566 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2679 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991741.264830001 | 2097200.972 | 37.738039538296206 | -122.471079130991 | (37.7380395382962, -122.471079130991) | |||
132461 | 132461 | 206523 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2690 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5991790.63989 | 2097130.86053 | 37.737849885658 | -122.470903312649 | (37.737849885658, -122.470903312649) | |||
171063 | 171063 | 206569 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2435 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992009.07535 | 2098867.5883299997 | 37.7426311295378 | -122.47027451837099 | (37.7426311295378, -122.470274518371) | |||
74719 | 74719 | 206524 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 35 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992940.67499 | 2098878.9332 | 37.742716096581894 | -122.467054169341 | (37.7427160965819, -122.467054169341) | |||
26843 | 26843 | 206525 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 35 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992946.5083 | 2098897.01812 | 37.7427660898953 | -122.46703531413 | (37.7427660898953, -122.46703531413) | |||
50429 | 50429 | 206526 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 35 Madrone Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992953.91132 | 2098913.47299 | 37.742811698104205 | -122.467010912843 | (37.7428116981042, -122.467010912843) | |||
132226 | 132226 | 206527 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 13 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992983.90563 | 2098997.49136 | 37.7430441224891 | -122.46691330850099 | (37.7430441224891, -122.466913308501) | |||
50360 | 50360 | 206528 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 13 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992986.65204 | 2099006.05822 | 37.7430678034305 | -122.466904434898 | (37.7430678034305, -122.466904434898) | |||
148248 | 148248 | 206529 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 13 Madrone Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992989.732419999 | 2099015.25675 | 37.7430932380525 | -122.466894452432 | (37.7430932380525, -122.466894452432) | |||
249 | 249 | 251254 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 330 09th Ave | 1 | unknown : Cutout 12 | Tree 1 | MTA 6 | 3x3 | 5993109.0 | 2113253.0 | 37.782193225103605 | -122.467517213871 | (37.7821932251036, -122.467517213871) | ||||
167733 | 167733 | 206503 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1957 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993135.46016 | 2102179.05998 | 37.751788644440495 | -122.46662048837 | (37.7517886444405, -122.46662048837) | |||
26518 | 26518 | 206504 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1959 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5993136.05327 | 2102151.01657 | 37.7517116786758 | -122.46661639913602 | (37.7517116786758, -122.466616399136) | |||
28309 | 28309 | 206505 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1965 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993138.76599 | 2102124.2403700002 | 37.7516383146611 | -122.46660507218701 | (37.7516383146611, -122.466605072187) | |||
33381 | 33381 | 206506 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1985 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5993143.71774 | 2101970.98373 | 37.7512177970674 | -122.46657681008301 | (37.7512177970674, -122.466576810083) | |||
137122 | 137122 | 206507 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1985 10th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5993144.62205 | 2101960.97627 | 37.751190371338 | -122.46657295558599 | (37.751190371338, -122.466572955586) | |||
189037 | 189037 | 206564 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2044 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993156.7665 | 2101574.66751 | 37.7501303674196 | -122.46650288401399 | (37.7501303674196, -122.466502884014) | |||
64939 | 64939 | 206563 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2047 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993157.06576 | 2101533.95115 | 37.750018588 | -122.466498890138 | (37.750018588, -122.466498890138) | |||
132401 | 132401 | 206621 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1912 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993175.256709999 | 2102431.1044799997 | 37.7524829903015 | -122.46650118519301 | (37.7524829903015, -122.466501185193) | |||
49647 | 49647 | 206622 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1912 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993175.38418 | 2102417.55667 | 37.752445798858396 | -122.466499759777 | (37.7524457988584, -122.466499759777) | |||
44510 | 44510 | 218322 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 420 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5993190.15092 | 2099959.3697 | 37.745697098249394 | -122.466270063011 | (37.7456970982494, -122.466270063011) | |||
23989 | 23989 | 206572 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 51 Cortes Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993215.16949 | 2099646.04946 | 37.7448382439064 | -122.466160788211 | (37.7448382439064, -122.466160788211) | |||
56319 | 56319 | 206573 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 51 Cortes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993216.90415 | 2099626.41246 | 37.7447844257663 | -122.466153363383 | (37.7447844257663, -122.466153363383) | |||
40559 | 40559 | 206571 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 51 Cortes Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993219.180819999 | 2099666.63445 | 37.7448949964991 | -122.466148413523 | (37.7448949964991, -122.466148413523) | |||
62866 | 62866 | 206570 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 4 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993230.1067699995 | 2099675.67045 | 37.7449204374235 | -122.46611129043 | (37.7449204374235, -122.46611129043) | |||
66424 | 66424 | 206580 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 275 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993286.92729 | 2099684.15258 | 37.7449470052046 | -122.46591543334401 | (37.7449470052046, -122.465915433344) | |||
133199 | 133199 | 206579 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 275 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993299.1056 | 2099684.88554 | 37.744949720257004 | -122.46587337656601 | (37.744949720257, -122.465873376566) | |||
33279 | 33279 | 206578 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 275 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993312.03833 | 2099686.0969 | 37.7449537923783 | -122.46582874591199 | (37.7449537923783, -122.465828745912) | |||
166442 | 166442 | 206532 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 San Aleso Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993345.963169999 | 2094536.94274 | 37.730817459756 | -122.46533747775 | (37.730817459756, -122.46533747775) | |||
70255 | 70255 | 206531 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993348.57217 | 2094559.38972 | 37.730879244086296 | -122.46533008801399 | (37.7308792440863, -122.465330088014) | |||
73447 | 73447 | 206502 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 245 Lawton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993453.26762 | 2104570.92091 | 37.7583744121607 | -122.465695235269 | (37.7583744121607, -122.465695235269) | |||
32853 | 32853 | 206501 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 245 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993462.44278 | 2104571.8221299998 | 37.7583774159051 | -122.465663569242 | (37.7583774159051, -122.465663569242) | |||
185239 | 185239 | 206500 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 245 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993474.546519999 | 2104572.66216 | 37.7583804205467 | -122.465621770525 | (37.7583804205467, -122.465621770525) | |||
157581 | 157581 | 206499 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 245 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993488.07663 | 2104571.6485200003 | 37.7583784177465 | -122.46557490416001 | (37.7583784177465, -122.46557490416) | |||
53148 | 53148 | 206498 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 245 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993516.66966 | 2104572.87128 | 37.7583834242608 | -122.465476106443 | (37.7583834242608, -122.465476106443) | |||
41542 | 41542 | 206581 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 190 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993591.13879 | 2099773.66773 | 37.745210335700605 | -122.46487003355301 | (37.7452103357006, -122.464870033553) | |||
40135 | 40135 | 206582 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 190 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993610.53275 | 2099775.23813 | 37.745215765798996 | -122.464803087101 | (37.745215765799, -122.464803087101) | |||
72889 | 72889 | 206577 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 215 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993636.2641900005 | 2099712.16168 | 37.745044057332294 | -122.464709533316 | (37.7450440573323, -122.464709533316) | |||
148911 | 148911 | 206583 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993643.85712 | 2099778.24608 | 37.7452259461282 | -122.464688076401 | (37.7452259461282, -122.464688076401) | |||
136744 | 136744 | 206664 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 135 San Marcos Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5993646.4962 | 2100328.84926 | 37.7467379151376 | -122.464718926731 | (37.7467379151376, -122.464718926731) | |||
72855 | 72855 | 206620 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2105 09th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993657.1596800005 | 2101227.85905 | 37.7492069822304 | -122.464747327347 | (37.7492069822304, -122.464747327347) | |||
44246 | 44246 | 206584 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993659.8453 | 2099783.1011200002 | 37.745240198571295 | -122.464633144905 | (37.7452401985713, -122.464633144905) | |||
45428 | 45428 | 206576 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 100 Montalvo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993684.51151 | 2099645.64672 | 37.744864205510204 | -122.46453787523501 | (37.7448642055102, -122.464537875235) | |||
153258 | 153258 | 206575 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 120 Montalvo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993692.18131 | 2099632.63233 | 37.744828913423 | -122.464510409921 | (37.744828913423, -122.464510409921) | |||
47868 | 47868 | 206574 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 120 Montalvo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993698.095930001 | 2099619.5133 | 37.744793232835605 | -122.464489006068 | (37.7447932328356, -122.464489006068) | |||
165477 | 165477 | 206591 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 101 Montalvo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993709.625030001 | 2099698.37793 | 37.745010439781296 | -122.464454865994 | (37.7450104397813, -122.464454865994) | |||
30002 | 30002 | 206592 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 101 Montalvo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993721.8716 | 2099672.6551599996 | 37.744940517497 | -122.464410652624 | (37.744940517497, -122.464410652624) | |||
67024 | 67024 | 206497 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1616 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5993722.387569999 | 2104477.6450099996 | 37.7581338201448 | -122.464757733396 | (37.7581338201448, -122.464757733396) | |||
75402 | 75402 | 206548 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 Dorantes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5993741.1056699995 | 2099827.07051 | 37.7453656117262 | -122.464355354239 | (37.7453656117262, -122.464355354239) | |||
39199 | 39199 | 206623 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1964 08th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993824.3832 | 2102096.20379 | 37.7516008749812 | -122.464232103026 | (37.7516008749812, -122.464232103026) | |||
58785 | 58785 | 206665 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 11 Santa Rita Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993870.76921 | 2100887.71242 | 37.748285339014295 | -122.463983980089 | (37.7482853390143, -122.463983980089) | |||
76722 | 76722 | 206547 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 120 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993889.308780001 | 2099967.60077 | 37.7457600139093 | -122.463853094571 | (37.7457600139093, -122.463853094571) | |||
46146 | 46146 | 206555 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 47 Sotelo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5993893.29504 | 2101174.89341 | 37.74907516320621 | -122.463926929805 | (37.7490751632062, -122.463926929805) | |||
151567 | 151567 | 206554 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 47 Sotelo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5993895.61602 | 2101166.1129900003 | 37.749051188161296 | -122.46391826663401 | (37.7490511881613, -122.463918266634) | |||
27341 | 27341 | 206556 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 32 Sotelo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5993935.86279 | 2101082.16601 | 37.7488230103837 | -122.463773001819 | (37.7488230103837, -122.463773001819) | |||
153873 | 153873 | 206585 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 368 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993961.3420400005 | 2099692.54098 | 37.745008919941 | -122.463584056983 | (37.745008919941, -122.463584056983) | |||
49358 | 49358 | 206666 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 15 Sotelo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993976.53914 | 2100938.08553 | 37.74842974584271 | -122.46362188875901 | (37.7484297458427, -122.463621888759) | |||
61321 | 61321 | 206667 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 15 Sotelo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993986.73582 | 2100929.3593 | 37.74840637335971 | -122.46358599590499 | (37.7484063733597, -122.463585995905) | |||
34016 | 34016 | 206586 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 360 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993997.55659 | 2099722.78299 | 37.745094043463396 | -122.46346102880699 | (37.7450940434634, -122.463461028807) | |||
64527 | 64527 | 206668 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 15 Sotelo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993998.36893 | 2100916.3469700003 | 37.7483713150869 | -122.46354482495501 | (37.7483713150869, -122.463544824955) | |||
39798 | 39798 | 206669 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 15 Sotelo Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994007.62455 | 2100906.4247 | 37.74834460433671 | -122.463512099503 | (37.7483446043367, -122.463512099503) | |||
56263 | 56263 | 206670 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 15 Sotelo Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994011.71818 | 2100897.82655 | 37.7483212318599 | -122.463497320046 | (37.7483212318599, -122.463497320046) | |||
151744 | 151744 | 218121 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 45 Lopez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5994024.91011 | 2100655.57636 | 37.7476568343048 | -122.463434125583 | (37.7476568343048, -122.463434125583) | |||
29530 | 29530 | 218122 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 45 Lopez Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5994032.10421 | 2100668.86964 | 37.7476937487685 | -122.463410213512 | (37.7476937487685, -122.463410213512) | |||
43524 | 43524 | 206628 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 20 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5994037.30563 | 2101977.91794 | 37.7512883623694 | -122.463487212563 | (37.7512883623694, -122.463487212563) | |||
179119 | 179119 | 206587 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 348 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994044.71238 | 2099771.06427 | 37.745229328484704 | -122.46330147648099 | (37.7452293284847, -122.463301476481) | |||
39280 | 39280 | 206536 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 401 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994052.44062 | 2101520.15999 | 37.7500323476354 | -122.463401659183 | (37.7500323476354, -122.463401659183) | |||
158121 | 158121 | 206588 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 348 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994058.29292 | 2099782.40477 | 37.7452612490171 | -122.463255340382 | (37.7452612490171, -122.463255340382) | |||
188058 | 188058 | 206537 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 401 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994067.3294 | 2101503.80633 | 37.7499883024325 | -122.46334898679 | (37.7499883024325, -122.46334898679) | |||
175013 | 175013 | 206619 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 181 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994070.38957 | 2104649.5630900003 | 37.758625920162295 | -122.463566678468 | (37.7586259201623, -122.463566678468) | |||
186378 | 186378 | 206627 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 40 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994076.75455 | 2101874.6545700002 | 37.751007100296604 | -122.463343302157 | (37.7510071002966, -122.463343302157) | |||
184549 | 184549 | 206626 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 40 Ventura Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994084.99265 | 2101862.2244599997 | 37.750973444992205 | -122.46331391231199 | (37.7509734449922, -122.463313912312) | |||
64063 | 64063 | 122404 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 340 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 5994085.0 | 2099826.0 | 37.74538248907739 | -122.46316615516001 | (37.7453824890774, -122.46316615516) | ||||
139071 | 139071 | 122405 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 340 Magellan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 5994085.0 | 2099826.0 | 37.74538248907739 | -122.46316615516001 | (37.7453824890774, -122.46316615516) | ||||
157297 | 157297 | 206589 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 340 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5994086.716030001 | 2099812.2565200003 | 37.7453448518007 | -122.463159224416 | (37.7453448518007, -122.463159224416) | |||
133979 | 133979 | 206590 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 340 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994099.18491 | 2099823.6206900002 | 37.745376773231 | -122.463116933812 | (37.745376773231, -122.463116933812) | |||
66445 | 66445 | 206538 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 399 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994103.277319999 | 2101446.93652 | 37.749834223367294 | -122.463220551898 | (37.7498342233673, -122.463220551898) |
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");