trees
493 rows where qSpecies_id = 133 sorted by qSiteInfo descending
This data as json, CSV (advanced)
qLegalStatus_id ✖
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 156649 | 251254 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 330 09th Ave | 1 | unknown : Cutout | Tree | MTA 3 | 3x3 | 5993109 | 2113253 | 37.7821932251036 | -122.467517213871 | (37.7821932251036, -122.467517213871) | 11 | 6 | 2 | 54 | 11 | ||||
| 8188 | 126379 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1136 Havens St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 6007507.74968 | 2119357.27743 | 37.7997748437807 | -122.418136782297 | (37.7997748437807, -122.418136782297) | 5 | 1 | 1 | 28858 | 32 | |||
| 19680 | 206561 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 355 Yerba Buena Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5995302.34368 | 2095238.16689 | 37.732855482695 | -122.458624745542 | (37.732855482695, -122.458624745542) | 9 | 7 | 4 | 59 | 40 | |||
| 32357 | 126382 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1001 Vallejo St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6008670.39988 | 2118624.74661 | 37.7978288673746 | -122.414061717575 | (37.7978288673746, -122.414061717575) | 5 | 1 | 10 | 308 | 21 | |||
| 40567 | 206697 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998934.95382 | 2095541.69667 | 37.7338970145182 | -122.446087759167 | (37.7338970145182, -122.446087759167) | 9 | 7 | 4 | 59 | 40 | |||
| 66765 | 206560 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 355 Yerba Buena Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995304.48103 | 2095229.25095 | 37.7328311245367 | -122.458616711016 | (37.7328311245367, -122.458616711016) | 9 | 7 | 4 | 59 | 40 | |||
| 72896 | 206698 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998920.6207 | 2095542.64427 | 37.7338987978865 | -122.446137381059 | (37.7338987978865, -122.446137381059) | 9 | 7 | 4 | 59 | 40 | |||
| 96906 | 206702 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5998869.22619 | 2095565.73707 | 37.7339592701108 | -122.446316727449 | (37.7339592701108, -122.446316727449) | 9 | 7 | 4 | 59 | 40 | |||
| 108186 | 206701 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998876.80466 | 2095558.49789 | 37.7339398258586 | -122.446290005877 | (37.7339398258586, -122.446290005877) | 9 | 7 | 4 | 59 | 40 | |||
| 110640 | 206559 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 355 Yerba Buena Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995306.63453 | 2095221.10602 | 37.7328088843117 | -122.458608676455 | (37.7328088843117, -122.458608676455) | 9 | 7 | 4 | 59 | 40 | |||
| 124900 | 190927 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1050 Wisconsin St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6012767.00645 | 2102579.68997 | 37.7540020378723 | -122.39875959738 | (37.7540020378723, -122.39875959738) | 10 | 3 | 8 | 28856 | 29 | |||
| 137361 | 206699 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998907.63682 | 2095545.72944 | 37.7339065275492 | -122.446182491946 | (37.7339065275492, -122.446182491946) | 9 | 7 | 4 | 59 | 40 | |||
| 164255 | 126380 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1136 Havens St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 6007510.81799 | 2119357.46903 | 37.7997755425663 | -122.418126178374 | (37.7997755425663, -122.418126178374) | 5 | 1 | 1 | 28858 | 32 | |||
| 180178 | 206664 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 135 San Marcos Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5993646.4962 | 2100328.84926 | 37.7467379151376 | -122.464718926731 | (37.7467379151376, -122.464718926731) | 1 | 8 | 4 | 29491 | 40 | |||
| 180598 | 206700 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998900.28229 | 2095547.61505 | 37.7339112849776 | -122.446208054284 | (37.7339112849776, -122.446208054284) | 9 | 7 | 4 | 59 | 40 | |||
| 28142 | 121663 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
| 62246 | 121661 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
| 86826 | 121662 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
| 162377 | 121664 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
| 179732 | 121660 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
| 12800 | 206586 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 360 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993997.55659 | 2099722.78299 | 37.7450940434634 | -122.463461028807 | (37.7450940434634, -122.463461028807) | 1 | 8 | 4 | 29491 | 40 | |||
| 16321 | 206539 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 393 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994118.07071 | 2101419.5251 | 37.749759810788 | -122.463167407365 | (37.749759810788, -122.463167407365) | 1 | 8 | 4 | 29491 | 40 | |||
| 17056 | 206626 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 40 Ventura Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994084.99265 | 2101862.22446 | 37.7509734449922 | -122.463313912312 | (37.7509734449922, -122.463313912312) | 1 | 8 | 4 | 29491 | 40 | |||
| 20290 | 206629 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 81 Ventura Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994298.95446 | 2101835.26425 | 37.7509117433916 | -122.462572061571 | (37.7509117433916, -122.462572061571) | 1 | 8 | 4 | 29491 | 40 | |||
| 24681 | 206641 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 196 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994436.73351 | 2100801.00946 | 37.7480798753848 | -122.462020618849 | (37.7480798753848, -122.462020618849) | 1 | 8 | 4 | 29491 | 40 | |||
| 25644 | 206545 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 265 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5994446.42204 | 2100465.35227 | 37.747158803252 | -122.461962779858 | (37.747158803252, -122.461962779858) | 1 | 8 | 4 | 29491 | 40 | |||
| 25861 | 206613 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 432 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5995024.84981 | 2100327.10403 | 37.7468124923186 | -122.459952623323 | (37.7468124923186, -122.459952623323) | 1 | 8 | 4 | 29491 | 40 | |||
| 27348 | 206661 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 390 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994161.93741 | 2101486.33597 | 37.7499457833913 | -122.463020562465 | (37.7499457833913, -122.463020562465) | 1 | 8 | 4 | 29491 | 40 | |||
| 28527 | 206648 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Castenada Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994513.85188 | 2100887.12446 | 37.748320765087 | -122.461760191398 | (37.748320765087, -122.461760191398) | 1 | 8 | 4 | 29491 | 40 | |||
| 31183 | 206625 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 80 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994283.13326 | 2101793.571 | 37.7507963531822 | -122.46262374829 | (37.7507963531822, -122.46262374829) | 1 | 8 | 4 | 29491 | 40 | |||
| 35026 | 206591 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 101 Montalvo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5993709.62503 | 2099698.37793 | 37.7450104397813 | -122.464454865994 | (37.7450104397813, -122.464454865994) | 1 | 8 | 4 | 29491 | 40 | |||
| 37635 | 206573 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 51 Cortes Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993216.90415 | 2099626.41246 | 37.7447844257663 | -122.466153363383 | (37.7447844257663, -122.466153363383) | 1 | 8 | 4 | 29491 | 40 | |||
| 38300 | 206652 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994516.45103 | 2100943.31749 | 37.7484752065739 | -122.4617552775 | (37.7484752065739, -122.4617552775) | 1 | 8 | 4 | 29491 | 40 | |||
| 39404 | 206537 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 401 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994067.3294 | 2101503.80633 | 37.7499883024325 | -122.46334898679 | (37.7499883024325, -122.46334898679) | 1 | 8 | 4 | 29491 | 40 | |||
| 39852 | 206617 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 198 Garcia Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5994686.63181 | 2099351.09779 | 37.7441131663853 | -122.461051409618 | (37.7441131663853, -122.461051409618) | 1 | 8 | 4 | 59 | 40 | |||
| 40090 | 206631 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 89 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994365.26522 | 2101880.85976 | 37.7510407556506 | -122.462346061026 | (37.7510407556506, -122.462346061026) | 1 | 8 | 4 | 29491 | 40 | |||
| 40920 | 206659 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 41 Alton Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994198.61036 | 2101541.1054 | 37.750098278721 | -122.462897719553 | (37.750098278721, -122.462897719553) | 1 | 8 | 4 | 29491 | 40 | |||
| 42334 | 206608 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2 Sola Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5994960.81371 | 2100721.5804 | 37.7478919422595 | -122.460202627649 | (37.7478919422595, -122.460202627649) | 1 | 8 | 4 | 29491 | 40 | |||
| 44186 | 206624 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 80 Ventura Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994298.51296 | 2101800.25271 | 37.7508155851791 | -122.46257104893 | (37.7508155851791, -122.46257104893) | 1 | 8 | 4 | 29491 | 40 | |||
| 45462 | 206618 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 198 Garcia Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | Permit Number 779324 | 5994673.79551 | 2099409.87557 | 37.7442738167873 | -122.461100053935 | (37.7442738167873, -122.461100053935) | 1 | 8 | 4 | 59 | 40 | ||
| 45592 | 206647 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Castenada Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994503.49405 | 2100867.53113 | 37.748266370491 | -122.461794587759 | (37.748266370491, -122.461794587759) | 1 | 8 | 4 | 29491 | 40 | |||
| 46206 | 206638 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 167 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994538.83302 | 2100858.65401 | 37.7482440304446 | -122.46167174395 | (37.7482440304446, -122.46167174395) | 1 | 8 | 4 | 29491 | 40 | |||
| 48224 | 206660 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 41 Alton Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994227.71262 | 2101539.78712 | 37.7500963352778 | -122.462796987411 | (37.7500963352778, -122.462796987411) | 1 | 8 | 4 | 29491 | 40 | |||
| 50752 | 206547 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 120 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993889.30878 | 2099967.60077 | 37.7457600139093 | -122.463853094571 | (37.7457600139093, -122.463853094571) | 1 | 8 | 4 | 29491 | 40 | |||
| 52410 | 206639 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 175 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994510.39425 | 2100823.87441 | 37.7481468973818 | -122.461767562235 | (37.7481468973818, -122.461767562235) | 1 | 8 | 4 | 29491 | 40 | |||
| 52801 | 206552 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 308 Pacheco St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5994313.1172 | 2100803.87721 | 37.7480806317257 | -122.462448284279 | (37.7480806317257, -122.462448284279) | 1 | 8 | 4 | 29491 | 40 | |||
| 54867 | 206505 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1965 10th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993138.76599 | 2102124.24037 | 37.7516383146611 | -122.466605072187 | (37.7516383146611, -122.466605072187) | 1 | 8 | 4 | 29491 | 12 | |||
| 55707 | 206642 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 196 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994408.53923 | 2100777.89876 | 37.7480147959636 | -122.462116437149 | (37.7480147959636, -122.462116437149) | 1 | 8 | 4 | 29491 | 40 | |||
| 57243 | 206633 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 145 Castenada Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994552.30711 | 2100925.23177 | 37.7484276117632 | -122.461629977659 | (37.7484276117632, -122.461629977659) | 1 | 8 | 4 | 29491 | 40 | |||
| 58588 | 206536 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 401 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994052.44062 | 2101520.15999 | 37.7500323476354 | -122.463401659183 | (37.7500323476354, -122.463401659183) | 1 | 8 | 4 | 29491 | 40 | |||
| 59731 | 206585 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 368 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993961.34204 | 2099692.54098 | 37.745008919941 | -122.463584056983 | (37.745008919941, -122.463584056983) | 1 | 8 | 4 | 29491 | 40 | |||
| 61748 | 206655 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 45 Alton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994255.40167 | 2101538.85258 | 37.7500953640099 | -122.462701170033 | (37.7500953640099, -122.462701170033) | 1 | 8 | 4 | 29491 | 40 | |||
| 62868 | 206543 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 347 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994159.12368 | 2101087.06957 | 37.7488493371331 | -122.463001327749 | (37.7488493371331, -122.463001327749) | 1 | 8 | 4 | 29491 | 40 | |||
| 62897 | 206623 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1964 08th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993824.3832 | 2102096.20379 | 37.7516008749812 | -122.464232103026 | (37.7516008749812, -122.464232103026) | 1 | 8 | 4 | 29491 | 12 | |||
| 64571 | 206665 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 11 Santa Rita Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993870.76921 | 2100887.71242 | 37.7482853390143 | -122.463983980089 | (37.7482853390143, -122.463983980089) | 1 | 8 | 4 | 29491 | 40 | |||
| 68672 | 206540 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 387 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994134.95664 | 2101369.7507 | 37.7496241156629 | -122.463105404514 | (37.7496241156629, -122.463105404514) | 1 | 8 | 4 | 29491 | 40 | |||
| 68821 | 206588 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 348 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994058.29292 | 2099782.40477 | 37.7452612490171 | -122.463255340382 | (37.7452612490171, -122.463255340382) | 1 | 8 | 4 | 29491 | 40 | |||
| 70495 | 206635 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 145 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994551.94388 | 2100907.90537 | 37.7483800169362 | -122.461629977657 | (37.7483800169362, -122.461629977657) | 1 | 8 | 4 | 29491 | 40 | |||
| 70530 | 206606 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Magellan Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5995035.92285 | 2100721.97488 | 37.747897345392 | -122.459942934033 | (37.747897345392, -122.459942934033) | 1 | 8 | 4 | 29491 | 40 | |||
| 70575 | 206546 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 265 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5994442.89418 | 2100449.8026 | 37.747115904674 | -122.461973851414 | (37.747115904674, -122.461973851414) | 1 | 8 | 4 | 29491 | 40 | |||
| 73935 | 206644 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994467.924 | 2100831.48615 | 37.7481653523681 | -122.46191497372 | (37.7481653523681, -122.46191497372) | 1 | 8 | 4 | 29491 | 40 | |||
| 74040 | 206590 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 340 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994099.18491 | 2099823.62069 | 37.745376773231 | -122.463116933812 | (37.745376773231, -122.463116933812) | 1 | 8 | 4 | 29491 | 40 | |||
| 77327 | 206601 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5995052.26314 | 2100785.00395 | 37.7480713471357 | -122.459890995496 | (37.7480713471357, -122.459890995496) | 1 | 8 | 4 | 29491 | 40 | |||
| 77345 | 206554 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 47 Sotelo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5993895.61602 | 2101166.11299 | 37.7490511881613 | -122.463918266634 | (37.7490511881613, -122.463918266634) | 1 | 8 | 4 | 29491 | 40 | |||
| 77503 | 206587 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 348 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994044.71238 | 2099771.06427 | 37.7452293284847 | -122.463301476481 | (37.7452293284847, -122.463301476481) | 1 | 8 | 4 | 29491 | 40 | |||
| 78570 | 206653 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 150 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5994496.6283 | 2101014.48441 | 37.748669471824 | -122.46182898323 | (37.748669471824, -122.46182898323) | 1 | 8 | 4 | 29491 | 40 | |||
| 79407 | 206634 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 145 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994552.46207 | 2100915.67701 | 37.748401385725 | -122.461628749166 | (37.748401385725, -122.461628749166) | 1 | 8 | 4 | 29491 | 40 | |||
| 81319 | 206582 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 190 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993610.53275 | 2099775.23813 | 37.745215765799 | -122.464803087101 | (37.745215765799, -122.464803087101) | 1 | 8 | 4 | 29491 | 40 | |||
| 81352 | 206602 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Magellan Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5995047.85902 | 2100763.4476 | 37.7480119055303 | -122.459904663381 | (37.7480119055303, -122.459904663381) | 1 | 8 | 4 | 29491 | 40 | |||
| 83405 | 206668 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 15 Sotelo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993998.36893 | 2100916.34697 | 37.7483713150869 | -122.463544824955 | (37.7483713150869, -122.463544824955) | 1 | 8 | 4 | 29491 | 40 | |||
| 83897 | 206503 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1957 10th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993135.46016 | 2102179.05998 | 37.7517886444405 | -122.46662048837 | (37.7517886444405, -122.46662048837) | 1 | 8 | 4 | 29491 | 12 | |||
| 84544 | 206550 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 308 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5994328.73662 | 2100761.78102 | 37.7479659456765 | -122.462391220472 | (37.7479659456765, -122.462391220472) | 1 | 8 | 4 | 29491 | 40 | |||
| 85200 | 206628 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 20 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5994037.30563 | 2101977.91794 | 37.7512883623694 | -122.463487212563 | (37.7512883623694, -122.463487212563) | 1 | 8 | 4 | 29491 | 40 | |||
| 86236 | 190926 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1303 Rhode Island St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6012003.88758 | 2102215.75937 | 37.7529602155494 | -122.401373086604 | (37.7529602155494, -122.401373086604) | 10 | 3 | 8 | 28856 | 29 | |||
| 88461 | 206579 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 275 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993299.1056 | 2099684.88554 | 37.744949720257 | -122.465873376566 | (37.744949720257, -122.465873376566) | 1 | 8 | 4 | 29491 | 40 | |||
| 92575 | 206640 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 175 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994518.44354 | 2100835.02583 | 37.7481779797266 | -122.461740536702 | (37.7481779797266, -122.461740536702) | 1 | 8 | 4 | 29491 | 40 | |||
| 98018 | 206657 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 41 Alton Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994149.03126 | 2101531.53277 | 37.7500691388799 | -122.463068471138 | (37.7500691388799, -122.463068471138) | 1 | 8 | 4 | 29491 | 40 | |||
| 101084 | 206615 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 198 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | Permit Number 779324 | 5994758.52704 | 2099346.29484 | 37.7441041156281 | -122.460802465585 | (37.7441041156281, -122.460802465585) | 1 | 8 | 4 | 59 | 40 | ||
| 102548 | 206614 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 432 Dewey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995034.15561 | 2100336.79731 | 37.7468396428317 | -122.459921147044 | (37.7468396428317, -122.459921147044) | 1 | 8 | 4 | 29491 | 40 | |||
| 103424 | 206620 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2105 09th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993657.15968 | 2101227.85905 | 37.7492069822304 | -122.464747327347 | (37.7492069822304, -122.464747327347) | 1 | 8 | 4 | 29491 | 40 | |||
| 103756 | 206658 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 41 Alton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994157.02115 | 2101539.85513 | 37.7500924502117 | -122.463041445619 | (37.7500924502117, -122.463041445619) | 1 | 8 | 4 | 29491 | 40 | |||
| 106812 | 206577 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 215 Dorantes Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5993636.26419 | 2099712.16168 | 37.7450440573323 | -122.464709533316 | (37.7450440573323, -122.464709533316) | 1 | 8 | 4 | 29491 | 40 | |||
| 108499 | 218322 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 420 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5993190.15092 | 2099959.3697 | 37.7456970982494 | -122.466270063011 | (37.7456970982494, -122.466270063011) | 1 | 8 | 4 | 29491 | 40 | |||
| 110051 | 206636 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 159 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994544.93698 | 2100878.69027 | 37.7482993963164 | -122.461652089281 | (37.7482993963164, -122.461652089281) | 1 | 8 | 4 | 29491 | 40 | |||
| 111308 | 206609 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 44 Sola Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994867.72907 | 2100768.79557 | 37.7480162285692 | -122.460527928626 | (37.7480162285692, -122.460527928626) | 1 | 8 | 4 | 29491 | 40 | |||
| 111783 | 206669 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 15 Sotelo Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994007.62455 | 2100906.4247 | 37.7483446043367 | -122.463512099503 | (37.7483446043367, -122.463512099503) | 1 | 8 | 4 | 29491 | 40 | |||
| 113884 | 206558 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 517 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5995506.85137 | 2100151.86426 | 37.7463590370584 | -122.458273237436 | (37.7463590370584, -122.458273237436) | 1 | 5 | 4 | 59 | 40 | |||
| 114209 | 206572 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 51 Cortes Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993215.16949 | 2099646.04946 | 37.7448382439064 | -122.466160788211 | (37.7448382439064, -122.466160788211) | 1 | 8 | 4 | 29491 | 40 | |||
| 114722 | 218122 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 45 Lopez Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5994032.10421 | 2100668.86964 | 37.7476937487685 | -122.463410213512 | (37.7476937487685, -122.463410213512) | 1 | 8 | 4 | 29491 | 40 | |||
| 117873 | 206667 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 15 Sotelo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993986.73582 | 2100929.3593 | 37.7484063733597 | -122.463585995905 | (37.7484063733597, -122.463585995905) | 1 | 8 | 4 | 29491 | 40 | |||
| 118462 | 206589 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 340 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994086.71603 | 2099812.25652 | 37.7453448518007 | -122.463159224416 | (37.7453448518007, -122.463159224416) | 1 | 8 | 4 | 29491 | 40 | |||
| 123636 | 182596 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 945 Rivera St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5990197.9307 | 2100380.5725 | 37.7466805119975 | -122.47664737489 | (37.7466805119975, -122.47664737489) | 1 | 8 | 3 | 29491 | 35 | |||
| 126946 | 206580 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 275 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993286.92729 | 2099684.15258 | 37.7449470052046 | -122.465915433344 | (37.7449470052046, -122.465915433344) | 1 | 8 | 4 | 29491 | 40 | |||
| 127586 | 206603 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Magellan Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5995045.25769 | 2100752.48094 | 37.7479816442318 | -122.459912864313 | (37.7479816442318, -122.459912864313) | 1 | 8 | 4 | 29491 | 40 | |||
| 128619 | 206610 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 49 Sola Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994851.29052 | 2100738.8321 | 37.7479330107067 | -122.46058260112 | (37.7479330107067, -122.46058260112) | 1 | 8 | 4 | 29491 | 40 | |||
| 129133 | 206670 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 15 Sotelo Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994011.71818 | 2100897.82655 | 37.7483212318599 | -122.463497320046 | (37.7483212318599, -122.463497320046) | 1 | 8 | 4 | 29491 | 40 | |||
| 132095 | 206645 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994475.58114 | 2100840.87711 | 37.7481915783923 | -122.461889176638 | (37.7481915783923, -122.461889176638) | 1 | 8 | 4 | 29491 | 40 | |||
| 133810 | 206583 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5993643.85712 | 2099778.24608 | 37.7452259461282 | -122.464688076401 | (37.7452259461282, -122.464688076401) | 1 | 8 | 4 | 29491 | 40 | |||
| 133847 | 206553 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 352 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5994206.92878 | 2101186.05332 | 37.74912387497 | -122.462843199074 | (37.74912387497, -122.462843199074) | 1 | 8 | 4 | 29491 | 40 | |||
| 134750 | 206557 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 517 Laguna Honda Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5995503.23656 | 2100160.44134 | 37.7463823798599 | -122.458286357642 | (37.7463823798599, -122.458286357642) | 1 | 5 | 4 | 59 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );