Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
553 | 553 | 206616 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Vasquez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 779324 | 5994742.56026 | 2099334.6803900003 | 37.7440713065495 | -122.460856833195 | (37.7440713065495, -122.460856833195) | ||
571 | 571 | 206618 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Garcia Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | Permit Number 779324 | 5994673.79551 | 2099409.87557 | 37.7442738167873 | -122.461100053935 | (37.7442738167873, -122.461100053935) | ||
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) | |||
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) | |||
30299 | 30299 | 206560 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 355 Yerba Buena Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995304.48103 | 2095229.25095 | 37.7328311245367 | -122.458616711016 | (37.7328311245367, -122.458616711016) | |||
33057 | 33057 | 206553 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 352 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 5994206.928780001 | 2101186.05332 | 37.74912387497 | -122.462843199074 | (37.74912387497, -122.462843199074) | |||
34122 | 34122 | 206658 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 41 Alton Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994157.02115 | 2101539.85513 | 37.7500924502117 | -122.463041445619 | (37.7500924502117, -122.463041445619) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
119316 | 119316 | 206672 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 370 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995263.98331 | 2095214.4393900002 | 37.732788127968995 | -122.458755649049 | (37.732788127969, -122.458755649049) | |||
126743 | 126743 | 223043 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 4107 Ogden Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008381.78974 | 2096055.8705400003 | 37.735843768863795 | -122.413463422917 | (37.7358437688638, -122.413463422917) | |||
126753 | 126753 | 206613 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 432 Dewey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5995024.84981 | 2100327.10403 | 37.746812492318604 | -122.459952623323 | (37.7468124923186, -122.459952623323) | |||
130265 | 130265 | 206637 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 159 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994549.87925 | 2100894.15199 | 37.7483421347836 | -122.461636120028 | (37.7483421347836, -122.461636120028) | |||
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) | |||
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) | |||
134479 | 134479 | 206645 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994475.58114 | 2100840.87711 | 37.748191578392294 | -122.461889176638 | (37.7481915783923, -122.461889176638) | |||
148350 | 148350 | 206542 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 351 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994154.36407 | 2101104.3868400003 | 37.748896611800106 | -122.46301904261999 | (37.7488966118001, -122.46301904262) | |||
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) | |||
151039 | 151039 | 206692 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 582 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5996416.06092 | 2095880.8714400001 | 37.7346841407625 | -122.45482078325199 | (37.7346841407625, -122.454820783252) | |||
151724 | 151724 | 206687 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 629 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996087.4467400005 | 2095957.96527 | 37.7348769661929 | -122.45596247889 | (37.7348769661929, -122.45596247889) | |||
152052 | 152052 | 223044 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 13 Stoneman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008324.57166 | 2099444.87133 | 37.7451460071793 | -122.413900908902 | (37.7451460071793, -122.413900908902) | |||
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) | |||
154984 | 154984 | 206629 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 81 Ventura Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994298.95446 | 2101835.26425 | 37.7509117433916 | -122.46257206157101 | (37.7509117433916, -122.462572061571) | |||
155591 | 155591 | 206679 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 657 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995939.36036 | 2096013.8239 | 37.7350218397738 | -122.456478499997 | (37.7350218397738, -122.456478499997) | |||
157129 | 157129 | 206655 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 45 Alton Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994255.40167 | 2101538.8525799997 | 37.7500953640099 | -122.462701170033 | (37.7500953640099, -122.462701170033) | |||
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) | |||
158004 | 158004 | 223037 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 203 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002071.560219999 | 2096098.27883 | 37.7356038810064 | -122.435283373351 | (37.7356038810064, -122.435283373351) | |||
162090 | 162090 | 206642 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 196 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994408.53923 | 2100777.89876 | 37.7480147959636 | -122.46211643714899 | (37.7480147959636, -122.462116437149) | |||
162977 | 162977 | 223033 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 281 Richland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006248.27078 | 2096110.4955099998 | 37.735873731571395 | -122.420843728155 | (37.7358737315714, -122.420843728155) | |||
164232 | 164232 | 206634 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 145 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994552.462069999 | 2100915.6770099998 | 37.748401385725 | -122.461628749166 | (37.748401385725, -122.461628749166) | |||
165652 | 165652 | 206674 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 300 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995208.64941 | 2095407.77696 | 37.7333158051714 | -122.458960944512 | (37.7333158051714, -122.458960944512) | |||
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) | |||
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) | |||
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) | |||
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) | |||
185968 | 185968 | 206624 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 80 Ventura Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994298.51296 | 2101800.2527099997 | 37.7508155851791 | -122.46257104893 | (37.7508155851791, -122.46257104893) | |||
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) | |||
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) |
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");