trees
36 rows where PlotSize = "Width 4ft" and qSpecies_id = 133
This data as json, CSV (advanced)
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 54562 | 206595 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 135 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5995084.10326 | 2100870.93077 | 37.7483091116899 | -122.459787117476 | (37.7483091116899, -122.459787117476) | 1 | 8 | 4 | 29491 | 40 | |||
| 56805 | 206593 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 187 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5995062.08104 | 2100706.46988 | 37.7478562769412 | -122.459851357851 | (37.7478562769412, -122.459851357851) | 1 | 8 | 4 | 29491 | 40 | |||
| 61980 | 206497 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1616 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5993722.38757 | 2104477.64501 | 37.7581338201448 | -122.464757733396 | (37.7581338201448, -122.464757733396) | 1 | 8 | 4 | 56 | 12 | |||
| 70335 | 206597 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 150 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5995049.66416 | 2100868.50319 | 37.7483004655893 | -122.459906030335 | (37.7483004655893, -122.459906030335) | 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 | |||
| 72984 | 206596 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 135 Magellan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5995085.45283 | 2100859.88169 | 37.7482788513041 | -122.459781650511 | (37.7482788513041, -122.459781650511) | 1 | 8 | 4 | 29491 | 40 | |||
| 74617 | 206562 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1478 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994313.38923 | 2105462.92602 | 37.7608732027602 | -122.462785287235 | (37.7608732027602, -122.462785287235) | 1 | 5 | 11 | 56 | 12 | |||
| 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 | |||
| 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 | |||
| 95037 | 206600 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 150 Magellan Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5995054.43703 | 2100813.29817 | 37.7481491609747 | -122.459885527604 | (37.7481491609747, -122.459885527604) | 1 | 8 | 4 | 29491 | 40 | |||
| 109919 | 206599 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 150 Magellan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5995053.98462 | 2100829.4455 | 37.7481934714657 | -122.459888261529 | (37.7481934714657, -122.459888261529) | 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 | |||
| 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 | |||
| 114823 | 223042 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 330 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006921.22556 | 2096271.82147 | 37.7363546053902 | -122.418528488295 | (37.7363546053902, -122.418528488295) | 2 | 7 | 7 | 28859 | 2 | |||
| 122610 | 176075 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 100 Capistrano Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6001444.80034 | 2093622.381 | 37.7287700227166 | -122.4372730928 | (37.7287700227166, -122.4372730928) | 9 | 7 | 6 | 28861 | 25 | |||
| 123072 | 206530 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 175 Garcia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994631.6545 | 2099433.40276 | 37.7443359914089 | -122.461247472601 | (37.7443359914089, -122.461247472601) | 1 | 8 | 4 | 59 | 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 | |||
| 133928 | 206594 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 135 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5995087.43611 | 2100841.34046 | 37.7482280558 | -122.459773449604 | (37.7482280558, -122.459773449604) | 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 | |||
| 137546 | 206604 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Magellan Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5995043.01031 | 2100739.53906 | 37.747945979831 | -122.45991969824 | (37.747945979831, -122.45991969824) | 1 | 8 | 4 | 29491 | 40 | |||
| 139066 | 206607 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2 Sola Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994975.69537 | 2100714.97086 | 37.7478746501056 | -122.460150689128 | (37.7478746501056, -122.460150689128) | 1 | 8 | 4 | 29491 | 40 | |||
| 140400 | 223031 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 38 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5998471.48427 | 2106911.98504 | 37.7650905653978 | -122.448508695418 | (37.7650905653978, -122.448508695418) | 15 | 5 | 11 | 29492 | 9 | |||
| 146225 | 206556 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 32 Sotelo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5993935.86279 | 2101082.16601 | 37.7488230103837 | -122.463773001819 | (37.7488230103837, -122.463773001819) | 1 | 8 | 4 | 29491 | 40 | |||
| 156321 | 206611 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 49 Sola Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994869.30829 | 2100730.97603 | 37.7479124764813 | -122.460519727717 | (37.7479124764813, -122.460519727717) | 1 | 8 | 4 | 29491 | 40 | |||
| 161052 | 206555 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 47 Sotelo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5993893.29504 | 2101174.89341 | 37.7490751632062 | -122.463926929805 | (37.7490751632062, -122.463926929805) | 1 | 8 | 4 | 29491 | 40 | |||
| 162209 | 206598 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 150 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5995052.00135 | 2100847.98673 | 37.7482442669627 | -122.459896462476 | (37.7482442669627, -122.459896462476) | 1 | 8 | 4 | 29491 | 40 | |||
| 164367 | 206605 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Magellan Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5995038.86988 | 2100730.57279 | 37.7479211225827 | -122.459933366148 | (37.7479211225827, -122.459933366148) | 1 | 8 | 4 | 29491 | 40 | |||
| 171056 | 223027 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 116 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6004711.20676 | 2102860.50548 | 37.754320952762 | -122.426638485476 | (37.754320952762, -122.426638485476) | 2 | 4 | 5 | 28862 | 22 | |||
| 194061 | 206612 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 49 Sola Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5994889.66342 | 2100721.49656 | 37.7478876192364 | -122.460448654307 | (37.7478876192364, -122.460448654307) | 1 | 8 | 4 | 29491 | 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) );