trees
278 rows where SiteOrder = 1 and qSpecies_id = 133 sorted by qCareAssistant
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4563 | 223021 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 109 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006234.71683 | 2099501.18451 | 37.7451830394575 | -122.421131274692 | (37.7451830394575, -122.421131274692) | 2 | 7 | 7 | 28859 | 2 | |||
| 5637 | 223045 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 13 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008341.10325 | 2099446.02772 | 37.7451501107949 | -122.413843827126 | (37.7451501107949, -122.413843827126) | 2 | 7 | 7 | 28859 | 2 | |||
| 7001 | 225622 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 67 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5997067.03037 | 2106173.30325 | 37.7629819312842 | -122.453312997018 | (37.7629819312842, -122.453312997018) | 15 | 5 | 11 | 29492 | 12 | |||
| 8549 | 206676 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 240 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994971.50428 | 2095856.22795 | 37.7345335069973 | -122.459813287749 | (37.7345335069973, -122.459813287749) | 9 | 7 | 4 | 59 | 40 | |||
| 10122 | 52665 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1200 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774794 | 6000815 | 2109317 | 37.77182785317 | -122.440575583218 | (37.77182785317, -122.440575583218) | 15 | 5 | 11 | 29492 | 9 | |
| 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 | |||
| 16376 | 190928 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1778 Quesada Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6014320.53257 | 2095360.07162 | 37.73426491189 | -122.392882024183 | (37.73426491189, -122.392882024183) | 10 | 3 | 8 | 58 | 1 | |||
| 18348 | 98409 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 55 19th Ave | 1 | Sidewalk: Curb side : | Tree | Private 2 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | 1 | 8 | 3 | 56 | 35 | |||||
| 18421 | 122404 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 340 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 5994085 | 2099826 | 37.7453824890774 | -122.46316615516 | (37.7453824890774, -122.46316615516) | 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 | |||
| 25370 | 28296 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1432 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2003 12:00:00 AM | 6 | 2X3 | 6005818.9272 | 2100626.68333 | 37.7482499542668 | -122.422648971496 | (37.7482499542668, -122.422648971496) | 2 | 4 | 5 | 28859 | 19 | ||
| 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 | |||
| 26895 | 24597 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 451 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1996 12:00:00 AM | 6 | 3X3 | 6007425.33634 | 2097280.23764 | 37.7391518611665 | -122.416856984981 | (37.7391518611665, -122.416856984981) | 2 | 7 | 7 | 28859 | 2 | ||
| 27447 | 223034 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 578 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007664.49403 | 2096661.03983 | 37.7374651296141 | -122.415986246062 | (37.7374651296141, -122.415986246062) | 2 | 7 | 7 | 28859 | 2 | |||
| 28113 | 206685 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 641 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996053.59921 | 2095980.96691 | 37.734938180348 | -122.456081163331 | (37.734938180348, -122.456081163331) | 9 | 7 | 4 | 59 | 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 | |||
| 32772 | 255586 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 157 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006708 | 2105213 | 37.760893044988 | -122.419899978675 | (37.760893044988, -122.419899978675) | 2 | 4 | 7 | 28859 | 19 | ||||
| 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 | |||
| 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 | |||
| 40601 | 223023 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 330 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006515.40022 | 2104174.73701 | 37.7580313639845 | -122.420492397202 | (37.7580313639845, -122.420492397202) | 2 | 4 | 7 | 28859 | 19 | |||
| 42279 | 126381 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1022 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6008596.52569 | 2118672.84077 | 37.7979567725457 | -122.414320748412 | (37.7979567725457, -122.414320748412) | 5 | 1 | 10 | 308 | 21 | ||||
| 44249 | 24588 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 820 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/1996 12:00:00 AM | 20 | 3X3 | 6008195.26733 | 2097153.24719 | 37.7388464504963 | -122.414185921141 | (37.7388464504963, -122.414185921141) | 2 | 7 | 7 | 28859 | 2 | ||
| 45262 | 94075 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53465 | 5996116 | 2095941 | 37.734832022473 | -122.455862534884 | (37.734832022473, -122.455862534884) | 9 | 7 | 4 | 59 | 40 | ||
| 45301 | 206523 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2690 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991790.63989 | 2097130.86053 | 37.737849885658 | -122.470903312649 | (37.737849885658, -122.470903312649) | 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 | |||
| 47287 | 82780 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 3946 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50814 | 6003353.51076321 | 2104798.51931181 | 37.7595654262957 | -122.43147208276 | (37.7595654262957, -122.43147208276) | 2 | 4 | 5 | 28862 | 3 | ||
| 47724 | 184366 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2295 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5987606.9921 | 2099709.6419 | 37.7446876937291 | -122.485557233352 | (37.7446876937291, -122.485557233352) | 1 | 8 | 3 | 29491 | 35 | |||
| 47735 | 206689 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 616 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996145.20311 | 2095954.15677 | 37.734869823774 | -122.455762520949 | (37.734869823774, -122.455762520949) | 9 | 7 | 4 | 59 | 40 | |||
| 47942 | 48500 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1584(REVISED) Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2003 12:00:00 AM | Permit Number 46340 | 5998006.8549345 | 2108237.90665559 | 37.7687046321234 | -122.450211308243 | (37.7687046321234, -122.450211308243) | 15 | 5 | 11 | 29492 | 9 | |||
| 49813 | 206568 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2515 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991380.56657 | 2098286.24678 | 37.7409985569439 | -122.472405327055 | (37.7409985569439, -122.472405327055) | 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 | |||
| 52294 | 28791 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2737 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008967.21311 | 2102509.30076 | 37.7535963186214 | -122.411895265148 | (37.7535963186214, -122.411895265148) | 2 | 4 | 7 | 28859 | 19 | |||
| 52405 | 223051 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 24 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001422.87059 | 2107990.68113 | 37.7682207070445 | -122.438377882942 | (37.7682207070445, -122.438377882942) | 15 | 5 | 5 | 29492 | 3 | |||
| 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 | |||
| 54373 | 223035 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 99 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008263.26696 | 2099462.20339 | 37.7451901540099 | -122.414114116572 | (37.7451901540099, -122.414114116572) | 2 | 7 | 7 | 28859 | 2 | |||
| 54746 | 143086 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 459 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010641.4481 | 2120294.7479 | 37.8025247902186 | -122.407359099343 | (37.8025247902186, -122.407359099343) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 62155 | 206498 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5993516.66966 | 2104572.87128 | 37.7583834242608 | -122.465476106443 | (37.7583834242608, -122.465476106443) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |||
| 63519 | 206524 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 35 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992940.67499 | 2098878.9332 | 37.7427160965819 | -122.467054169341 | (37.7427160965819, -122.467054169341) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 65845 | 223047 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 3864 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6004003.36703 | 2102490.39098 | 37.7532646621477 | -122.429059987437 | (37.7532646621477, -122.429059987437) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 68840 | 206686 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996075.55271 | 2095969.20127 | 37.7349071348466 | -122.456004412496 | (37.7349071348466, -122.456004412496) | 9 | 7 | 4 | 59 | 40 | |||
| 70202 | 223024 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 979 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009975.92603 | 2103539.78877 | 37.756482348292 | -122.408479582484 | (37.756482348292, -122.408479582484) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 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 | |||
| 70629 | 104352 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 304 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | Permit Number 770823 | 6001744.6 | 2103958.8 | 37.7571684409617 | -122.436976369496 | (37.7571684409617, -122.436976369496) | 2 | 4 | 5 | 28862 | 3 | |||
| 70967 | 28792 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2731 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008964.24348 | 2102548.86607 | 37.7537047894643 | -122.411908330514 | (37.7537047894643, -122.411908330514) | 2 | 4 | 7 | 28859 | 19 | |||
| 72421 | 206678 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 657 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995925.9256 | 2096013.73306 | 37.7350208190394 | -122.456524941888 | (37.7350208190394, -122.456524941888) | 9 | 7 | 4 | 59 | 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 | |||
| 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 | |||
| 76261 | 26484 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 154 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6000987.64369 | 2098692.25572 | 37.7426647191989 | -122.439216742684 | (37.7426647191989, -122.439216742684) | 2 | 7 | 5 | 63 | 7 | |||
| 76572 | 223055 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 42 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002598.631 | 2096412.43412 | 37.7364963969952 | -122.433483533142 | (37.7364963969952, -122.433483533142) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |||
| 79608 | 206693 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 609 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997804.54909 | 2098010.1173 | 37.7406100866944 | -122.45017375512 | (37.7406100866944, -122.45017375512) | 9 | 7 | 4 | 59 | 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 | |||
| 81847 | 206567 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2523 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991381.76089 | 2098233.80223 | 37.7408546267459 | -122.472397375252 | (37.7408546267459, -122.472397375252) | 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 | |||
| 85167 | 223025 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 380 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005467.6636 | 2101500.58617 | 37.7506296665394 | -122.423925765973 | (37.7506296665394, -122.423925765973) | 2 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 87329 | 206675 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 300 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995199.65146 | 2095433.83543 | 37.733386838132 | -122.458993938825 | (37.733386838132, -122.458993938825) | 9 | 7 | 4 | 59 | 40 | |||
| 92618 | 223022 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 101 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6006257.51967 | 2099541.04409 | 37.7452937702941 | -122.42105525589 | (37.7452937702941, -122.42105525589) | 2 | 7 | 7 | 28859 | 2 | |||
| 92777 | 247816 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 550 30th St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6003030.78831 | 2098349.34835 | 37.7418392269952 | -122.432127661269 | (37.7418392269952, -122.432127661269) | 2 | 7 | 5 | 63 | 22 | |||
| 92863 | 47756 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 360St. Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2002 12:00:00 AM | Permit Number 45536 | 5994029.42937676 | 2099753.03047002 | 37.7451789317369 | -122.463353013703 | (37.7451789317369, -122.463353013703) | 1 | 8 | 4 | 29491 | 40 | |||
| 97367 | 206691 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 582 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5996439.41867 | 2095873.69496 | 37.7346657757093 | -122.454739509716 | (37.7346657757093, -122.454739509716) | 9 | 7 | 4 | 59 | 40 | |||
| 97453 | 206694 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 125 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001630.15209 | 2095380.35715 | 37.733607556928 | -122.43675811219 | (37.733607556928, -122.43675811219) | 9 | 7 | 5 | 63 | 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 | |||
| 98988 | 206622 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1912 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993175.38418 | 2102417.55667 | 37.7524457988584 | -122.466499759777 | (37.7524457988584, -122.466499759777) | 1 | 8 | 4 | 29491 | 12 | |||
| 99367 | 176074 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 786 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001892.13578 | 2089268.05693 | 37.7168394482606 | -122.435415271495 | (37.7168394482606, -122.435415271495) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | ||
| 101256 | 206522 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2204 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991046.63721 | 2100321.91518 | 37.7465686447317 | -122.473708385358 | (37.7465686447317, -122.473708385358) | 1 | 8 | 4 | 29491 | 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 | |||
| 103846 | 223050 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 18 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001422.84544 | 2108013.2139 | 37.7682825750187 | -122.438379584463 | (37.7682825750187, -122.438379584463) | 15 | 5 | 5 | 29492 | 3 | |||
| 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 | |||
| 110106 | 63000 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1251 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1986 12:00:00 AM | 2 | Permit Number 23408 | 5983028.2339 | 2106580.2336 | 37.7632845753318 | -122.501897691969 | (37.7632845753318, -122.501897691969) | 1 | 8 | 3 | 56 | 35 | ||
| 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 | |||
| 111061 | 223026 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 114 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004706.47094 | 2102901.67728 | 37.7544337331488 | -122.426657794828 | (37.7544337331488, -122.426657794828) | 2 | 4 | 5 | 28862 | 22 | |||
| 111111 | 137657 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2167 TURK BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999659.4785 | 2111881.8514 | 37.7788044135747 | -122.444756988886 | (37.7788044135747, -122.444756988886) | 15 | 5 | 11 | 29490 | 16 | |||
| 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 | |||
| 114901 | 126377 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 122 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6001345.97363 | 2121147.25207 | 37.8043408951819 | -122.439587150049 | (37.8043408951819, -122.439587150049) | 13 | 9 | 1 | 57 | 17 | |||
| 115707 | 94159 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1831 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53536 | 5993712.5 | 2103021.2 | 37.754134227954 | -122.464686168912 | (37.754134227954, -122.464686168912) | 1 | 8 | 4 | 56 | 12 | ||
| 116102 | 223039 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 543 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007708.38718 | 2096815.60919 | 37.7378920108046 | -122.415845428432 | (37.7378920108046, -122.415845428432) | 2 | 7 | 7 | 28859 | 2 | |||
| 116769 | 24553 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 404 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 6007222.65374 | 2097265.29025 | 37.7390994163072 | -122.417556712385 | (37.7390994163072, -122.417556712385) | 2 | 7 | 7 | 28859 | 2 | |||
| 117769 | 126378 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1976 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003585.79025 | 2118315.11213 | 37.7966917978451 | -122.431633760802 | (37.7966917978451, -122.431633760802) | 13 | 9 | 1 | 57 | 17 | |||
| 118553 | 206677 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 228 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994904.4684 | 2095946.32835 | 37.7347770452256 | -122.460051576629 | (37.7347770452256, -122.460051576629) | 9 | 7 | 4 | 59 | 40 | |||
| 118642 | 137632 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2175 TURK BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999619.2063 | 2111878.8056 | 37.7787937523144 | -122.444896086774 | (37.7787937523144, -122.444896086774) | 15 | 5 | 11 | 29490 | 16 | |||
| 119747 | 38530 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2550 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1998 12:00:00 AM | 3 | Permit Number 40512 | 5986784.3655 | 2097886.9498 | 37.7396351026284 | -122.48826775932 | (37.7396351026284, -122.48826775932) | 1 | 8 | 3 | 29491 | 35 | ||
| 123656 | 223036 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2743 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008969.13541 | 2102480.10351 | 37.7535162573804 | -122.411886554326 | (37.7535162573804, -122.411886554326) | 2 | 4 | 7 | 28859 | 19 | |||
| 124950 | 176073 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 774 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001923.16259 | 2089317.3719 | 37.7169766182659 | -122.43531155268 | (37.7169766182659, -122.43531155268) | 9 | 7 | 6 | 28861 | 5 | |||
| 125070 | 206527 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 13 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992983.90563 | 2098997.49136 | 37.7430441224891 | -122.466913308501 | (37.7430441224891, -122.466913308501) | 1 | 8 | 4 | 59 | 40 | |||
| 126152 | 206533 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 665 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5995361.50595 | 2093791.16395 | 37.7288857636427 | -122.458315510062 | (37.7288857636427, -122.458315510062) | 9 | 7 | 4 | 28861 | 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) );