Data source: data.sfgov.org
This data as json, CSV (advanced)
qLegalStatus ✖
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
50581 | 50581 | 38530 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2550 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/1998 12:00:00 AM | 3 | Permit Number 40512 | 5986784.3655 | 2097886.9498 | 37.7396351026284 | -122.48826775932 | (37.7396351026284, -122.48826775932) | ||
50876 | 50876 | 206684 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 647 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996011.49185 | 2096001.54035 | 37.7349922529962 | -122.456228229446 | (37.7349922529962, -122.456228229446) | |||
51326 | 51326 | 94076 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 629 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53465 | 5996116.0 | 2095941.0 | 37.734832022473 | -122.45586253488399 | (37.734832022473, -122.455862534884) | ||
51395 | 51395 | 206653 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 150 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994496.6283 | 2101014.48441 | 37.748669471824 | -122.46182898323 | (37.748669471824, -122.46182898323) | |||
51397 | 51397 | 206539 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 393 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994118.07071 | 2101419.5251 | 37.749759810788 | -122.46316740736499 | (37.749759810788, -122.463167407365) | |||
51664 | 51664 | 206697 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998934.9538199995 | 2095541.69667 | 37.733897014518206 | -122.446087759167 | (37.7338970145182, -122.446087759167) | |||
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) | |||
52114 | 52114 | 223023 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 330 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006515.400219999 | 2104174.73701 | 37.7580313639845 | -122.420492397202 | (37.7580313639845, -122.420492397202) | |||
52949 | 52949 | 206549 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 308 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994338.43004 | 2100748.81738 | 37.7479309089808 | -122.462356761175 | (37.7479309089808, -122.462356761175) | |||
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) | |||
53756 | 53756 | 206652 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994516.45103 | 2100943.3174900003 | 37.74847520657389 | -122.4617552775 | (37.7484752065739, -122.4617552775) | |||
54118 | 54118 | 206596 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 135 Magellan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5995085.45283 | 2100859.88169 | 37.7482788513041 | -122.459781650511 | (37.7482788513041, -122.459781650511) | |||
54773 | 54773 | 206638 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 167 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994538.83302 | 2100858.6540099997 | 37.7482440304446 | -122.46167174395 | (37.7482440304446, -122.46167174395) | |||
55162 | 55162 | 206635 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 145 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994551.94388 | 2100907.9053700003 | 37.7483800169362 | -122.461629977657 | (37.7483800169362, -122.461629977657) | |||
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) | |||
55439 | 55439 | 223036 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2743 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008969.13541 | 2102480.10351 | 37.7535162573804 | -122.411886554326 | (37.7535162573804, -122.411886554326) | |||
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) | |||
56091 | 56091 | 206541 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 375 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994147.31458 | 2101302.53521 | 37.7494402708691 | -122.463057794403 | (37.7494402708691, -122.463057794403) | |||
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) | |||
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) | |||
57368 | 57368 | 206595 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 135 Magellan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5995084.10326 | 2100870.93077 | 37.7483091116899 | -122.45978711747601 | (37.7483091116899, -122.459787117476) | |||
57787 | 57787 | 206540 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 387 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994134.95664 | 2101369.7507 | 37.7496241156629 | -122.46310540451401 | (37.7496241156629, -122.463105404514) | |||
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) | |||
58009 | 58009 | 206641 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 196 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994436.73351 | 2100801.00946 | 37.748079875384796 | -122.462020618849 | (37.7480798753848, -122.462020618849) | |||
58097 | 58097 | 206689 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 616 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5996145.20311 | 2095954.15677 | 37.734869823774 | -122.45576252094901 | (37.734869823774, -122.455762520949) | |||
58192 | 58192 | 31751 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2546 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 9 | Permit Number 35238 | 5989883.0648 | 2098033.3774 | 37.7402174568148 | -122.477564605136 | (37.7402174568148, -122.477564605136) | |
58539 | 58539 | 206598 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 150 Magellan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5995052.00135 | 2100847.98673 | 37.74824426696271 | -122.45989646247601 | (37.7482442669627, -122.459896462476) | |||
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) | |||
59046 | 59046 | 206654 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 45 Alton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994247.90783 | 2101537.24109 | 37.7500905076701 | -122.46272696707399 | (37.7500905076701, -122.462726967074) | |||
60482 | 60482 | 247587 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 800 Tompkins Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6008949.04431 | 2096428.8077599998 | 37.7368996080238 | -122.41152853331499 | (37.7368996080238, -122.411528533315) | ||||
61039 | 61039 | 206671 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 370 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995266.43425 | 2095204.88442 | 37.732762033223 | -122.45874648408899 | (37.732762033223, -122.458746484089) | |||
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) | |||
61636 | 61636 | 223021 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 109 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006234.71683 | 2099501.18451 | 37.7451830394575 | -122.421131274692 | (37.7451830394575, -122.421131274692) | |||
61905 | 61905 | 190927 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1050 Wisconsin St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6012767.00645 | 2102579.68997 | 37.7540020378723 | -122.39875959738 | (37.7540020378723, -122.39875959738) | |||
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) | |||
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) | |||
63202 | 63202 | 206604 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 Magellan Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5995043.01031 | 2100739.53906 | 37.747945979831 | -122.45991969824 | (37.747945979831, -122.45991969824) | |||
63545 | 63545 | 223038 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 10 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002089.19721 | 2096067.16423 | 37.7355194490575 | -122.435220170783 | (37.7355194490575, -122.435220170783) | |||
63732 | 63732 | 247588 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 800 Tompkins Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6008943.011630001 | 2096440.0672900002 | 37.7369301858647 | -122.411550186315 | (37.7369301858647, -122.411550186315) | ||||
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) | ||||
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) | |||
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) | |||
65033 | 65033 | 31914 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2286 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 4 | Permit Number 42223 | 5991731.014359999 | 2099907.3159 | 37.7454698746265 | -122.471311701978 | (37.7454698746265, -122.471311701978) | |
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) | |||
66433 | 66433 | 95111 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 649 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54039 | 6001701.74477 | 2093288.67335 | 37.727868340851295 | -122.43636094730101 | (37.7278683408513, -122.436360947301) |
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) | |||
66473 | 66473 | 206691 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 582 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5996439.41867 | 2095873.6949599998 | 37.734665775709296 | -122.45473950971599 | (37.7346657757093, -122.454739509716) | |||
66495 | 66495 | 206683 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 647 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995995.17419 | 2096006.3401799998 | 37.7350044954584 | -122.45628499197399 | (37.7350044954584, -122.456284991974) | |||
66581 | 66581 | 206606 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 Magellan Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5995035.92285 | 2100721.97488 | 37.747897345392 | -122.459942934033 | (37.747897345392, -122.459942934033) | |||
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) | |||
66828 | 66828 | 206680 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 657 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995948.68471 | 2096013.6289400002 | 37.73502183977529 | -122.456446248507 | (37.7350218397753, -122.456446248507) | |||
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) | |||
67067 | 67067 | 206660 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 41 Alton Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994227.712619999 | 2101539.78712 | 37.750096335277796 | -122.462796987411 | (37.7500963352778, -122.462796987411) | |||
68099 | 68099 | 206662 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 390 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994173.63187 | 2101468.0491400003 | 37.749896246027106 | -122.462978796147 | (37.7498962460271, -122.462978796147) | |||
68623 | 68623 | 63086 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1209 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1986 12:00:00 AM | 3 | Permit Number 23570 | 5983326.3714 | 2106866.623 | 37.7640884282736 | -122.500887729919 | (37.7640884282736, -122.500887729919) | ||
68999 | 68999 | 206663 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 390 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994181.82756 | 2101452.31219 | 37.7498535084399 | -122.46294931367399 | (37.7498535084399, -122.462949313674) | |||
69565 | 69565 | 206610 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 49 Sola Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994851.290519999 | 2100738.8321 | 37.7479330107067 | -122.46058260112 | (37.7479330107067, -122.46058260112) | |||
69745 | 69745 | 223042 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 330 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006921.22556 | 2096271.82147 | 37.736354605390204 | -122.418528488295 | (37.7363546053902, -122.418528488295) | |||
69773 | 69773 | 223051 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 24 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001422.87059 | 2107990.68113 | 37.7682207070445 | -122.438377882942 | (37.7682207070445, -122.438377882942) | |||
69850 | 69850 | 206611 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 49 Sola Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994869.30829 | 2100730.97603 | 37.7479124764813 | -122.460519727717 | (37.7479124764813, -122.460519727717) | |||
69893 | 69893 | 223047 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 3864 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6004003.36703 | 2102490.39098 | 37.7532646621477 | -122.429059987437 | (37.7532646621477, -122.429059987437) | |||
69957 | 69957 | 98409 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 55 19th Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | |||||
69960 | 69960 | 68121 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 101 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31868 | 6006245.31002458 | 2099503.96919514 | 37.745191282743896 | -122.421094842871 | (37.7451912827439, -122.421094842871) | ||
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) | |||
70261 | 70261 | 126380 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1136 Havens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 6007510.81799 | 2119357.46903 | 37.799775542566294 | -122.41812617837401 | (37.7997755425663, -122.418126178374) | |||
70281 | 70281 | 206632 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 99 Castenada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994454.48924 | 2101216.21265 | 37.749220940594604 | -122.46198932515 | (37.7492209405946, -122.46198932515) | |||
72284 | 72284 | 206690 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 616 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5996131.5818 | 2095962.98776 | 37.7348932897948 | -122.45581025245001 | (37.7348932897948, -122.45581025245) | |||
72290 | 72290 | 82688 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1875 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51093 | 5984404.185 | 2102433.03 | 37.7519782422196 | -122.496832705614 | (37.7519782422196, -122.496832705614) | |
72564 | 72564 | 206631 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 89 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994365.2652199995 | 2101880.85976 | 37.7510407556506 | -122.462346061026 | (37.7510407556506, -122.462346061026) | |||
72707 | 72707 | 190928 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1778 Quesada Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6014320.53257 | 2095360.07162 | 37.73426491189 | -122.39288202418301 | (37.73426491189, -122.392882024183) | |||
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) | |||
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) | |||
73002 | 73002 | 31750 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2546 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35238 | 5989885.0953 | 2098017.81 | 37.7401748305885 | -122.477556447005 | (37.7401748305885, -122.477556447005) | |
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) | |||
73565 | 73565 | 223025 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 380 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005467.6636 | 2101500.58617 | 37.750629666539396 | -122.423925765973 | (37.7506296665394, -122.423925765973) | |||
73810 | 73810 | 223029 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 170 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5997728.707169999 | 2104908.9589 | 37.75954826396 | -122.450933321612 | (37.75954826396, -122.450933321612) | |||
74063 | 74063 | 31296 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 431 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34940 | 5991578.61319 | 2097704.4347 | 37.7394125098801 | -122.47167817211201 | (37.7394125098801, -122.471678172112) | |
74097 | 74097 | 223041 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 410 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007256.618290001 | 2097259.39898 | 37.7390851512711 | -122.41743886071899 | (37.7390851512711, -122.417438860719) | |||
74247 | 74247 | 206636 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 159 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994544.936980001 | 2100878.69027 | 37.7482993963164 | -122.461652089281 | (37.7482993963164, -122.461652089281) | |||
74465 | 74465 | 206646 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994489.718859999 | 2100854.37735 | 37.7482294605322 | -122.46184126797701 | (37.7482294605322, -122.461841267977) | |||
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) | |||
74880 | 74880 | 41229 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 3618 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1999 12:00:00 AM | 5 | 3x3 | Permit Number 41935 | 6002621.77288 | 2121066.97203 | 37.8041929962699 | -122.435166401228 | (37.8041929962699, -122.435166401228) |
74950 | 74950 | 206661 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 390 Pacheco St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994161.93741 | 2101486.33597 | 37.7499457833913 | -122.463020562465 | (37.7499457833913, -122.463020562465) | |||
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) | |||
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) | |||
75436 | 75436 | 206640 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 175 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994518.44354 | 2100835.0258299997 | 37.7481779797266 | -122.46174053670201 | (37.7481779797266, -122.461740536702) | |||
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) | |||
76330 | 76330 | 126383 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1116 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6007504.98606 | 2119897.57415 | 37.801258207159 | -122.418184672095 | (37.801258207159, -122.418184672095) | ||||
76418 | 76418 | 206650 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Castenada Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994518.14401 | 2100922.4103 | 37.748417898168995 | -122.461747907542 | (37.748417898169, -122.461747907542) | |||
76521 | 76521 | 223030 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 125 Belgrave Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5997950.67072 | 2104889.0935 | 37.759506423000204 | -122.450164233094 | (37.7595064230002, -122.450164233094) | |||
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) | |||
77085 | 77085 | 206600 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 150 Magellan Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5995054.437030001 | 2100813.29817 | 37.748149160974705 | -122.459885527604 | (37.7481491609747, -122.459885527604) | |||
77157 | 77157 | 223048 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 3880 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6003922.515380001 | 2102484.70879 | 37.7532444831531 | -122.429339183778 | (37.7532444831531, -122.429339183778) | |||
77159 | 77159 | 176073 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 774 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001923.16259 | 2089317.3719 | 37.7169766182659 | -122.43531155267999 | (37.7169766182659, -122.43531155268) | |||
77448 | 77448 | 45122 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 201 Buena Vista Ave East | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | |||
77548 | 77548 | 51448 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 326 Bocana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | Permit Number 47765 | 6006818.05257651 | 2097195.51767411 | 37.7388850615796 | -122.41895069494 | (37.7388850615796, -122.41895069494) | |||
77680 | 77680 | 63803 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 75 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24490 | 6009186.19603238 | 2097034.65488427 | 37.7385764323817 | -122.41075136529899 | (37.7385764323817, -122.410751365299) | ||
77698 | 77698 | 68120 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 94 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31866 | 6006215.83488054 | 2099558.94321569 | 37.745340567320106 | -122.42120066595501 | (37.7453405673201, -122.421200665955) |
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");