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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
80996 | 80996 | 116196 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 3751 CLAY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996888.0 | 2115293.0 | 37.7880119756846 | -122.454591065245 | (37.7880119756846, -122.454591065245) | ||||
82108 | 82108 | 102412 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 55X Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000310.8 | 2109142.0 | 37.7713186232103 | -122.442307075209 | (37.7713186232103, -122.442307075209) | |||||
87649 | 87649 | 121661 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
89728 | 89728 | 82956 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 660X Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636.0 | 2110586.0 | 37.7758105844997 | -122.41015262108601 | (37.7758105844997, -122.410152621086) | |
96002 | 96002 | 82952 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 660X Clementina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636.0 | 2110586.0 | 37.7758105844997 | -122.41015262108601 | (37.7758105844997, -122.410152621086) | |
96209 | 96209 | 82955 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 660X Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636.0 | 2110586.0 | 37.7758105844997 | -122.41015262108601 | (37.7758105844997, -122.410152621086) | |
96465 | 96465 | 121662 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
100905 | 100905 | 82953 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 660X Clementina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636.0 | 2110586.0 | 37.7758105844997 | -122.41015262108601 | (37.7758105844997, -122.410152621086) | |
102428 | 102428 | 206562 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1478 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5994313.38923 | 2105462.92602 | 37.76087320276021 | -122.462785287235 | (37.7608732027602, -122.462785287235) | |||
107468 | 107468 | 84505 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 650 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2006 12:00:00 AM | 3 | 3x3 | 6009485.16866501 | 2110503.49163991 | 37.775575580460206 | -122.410668559049 | (37.7755755804602, -122.410668559049) | |
107733 | 107733 | 84504 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 650X Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2006 12:00:00 AM | 3 | 3x3 | 6009485.16866501 | 2110503.49163991 | 37.775575580460206 | -122.410668559049 | (37.7755755804602, -122.410668559049) | |
109122 | 109122 | 117509 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 300x HANOVER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999715.0 | 2086521.0 | 37.7091727618039 | -122.442743399736 | (37.7091727618039, -122.442743399736) | ||||
114401 | 114401 | 206552 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 308 Pacheco St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5994313.1172 | 2100803.87721 | 37.7480806317257 | -122.462448284279 | (37.7480806317257, -122.462448284279) | |||
115431 | 115431 | 223053 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 701 Church St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 3ft | 6004342.543869999 | 2104435.23189 | 37.7586239308804 | -122.42802562498998 | (37.7586239308804, -122.42802562499) | |||
116485 | 116485 | 200075 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1500 Van Dyke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6014900.2728 | 2093175.985 | 37.7283000356482 | -122.390725081061 | (37.7283000356482, -122.390725081061) | |||
117382 | 117382 | 82954 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 660X Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636.0 | 2110586.0 | 37.7758105844997 | -122.41015262108601 | (37.7758105844997, -122.410152621086) |
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");