trees
326 rows where qSpecies_id = 146 sorted by PlantDate
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 848 | 116677 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 100 Esmeralda Ave | 16 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
| 1866 | 150777 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2112 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6011789.01086 | 2103751.70928 | 37.7571656055116 | -122.402224155531 | (37.7571656055116, -122.402224155531) | 10 | 3 | 8 | 28856 | 29 | |||
| 6357 | 261583 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
| 6460 | 261585 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
| 6578 | 245102 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 250 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5999861.4659 | 2109378.2907 | 37.7719417978626 | -122.443878316418 | (37.7719417978626, -122.443878316418) | 15 | 5 | 11 | 29492 | 9 | |||
| 7505 | 247942 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 29 Joy St | 5 | Unaccepted Street : Yard | Tree | DPW 1 | 3 | Permit Number 775404 | 6010292.72224 | 2098904.67919 | 37.7437730949632 | -122.407057283984 | (37.7437730949632, -122.407057283984) | 2 | 7 | 7 | 28859 | 2 | |||
| 8012 | 222708 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 290 States St | 2 | Front Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6000342.85088 | 2106861.94292 | 37.7650599830613 | -122.442032523579 | (37.7650599830613, -122.442032523579) | 15 | 5 | 5 | 28862 | 3 | |||
| 8160 | 107407 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 171 TWIN PEAKS BLVD | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 5998631.4 | 2104681.4 | 37.7589750798494 | -122.447794991901 | (37.7589750798494, -122.447794991901) | 15 | 5 | 5 | 28862 | 12 | ||||
| 8999 | 222681 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2318 22nd St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6011232.98207 | 2103716.09635 | 37.7570367677534 | -122.404144621787 | (37.7570367677534, -122.404144621787) | 10 | 4 | 8 | 28859 | 19 | ||||
| 9333 | 261584 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
| 10245 | 222701 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 340 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004099.43344 | 2096524.74955 | 37.7368898251991 | -122.428302624264 | (37.7368898251991, -122.428302624264) | 2 | 7 | 5 | 63 | 7 | |||
| 10923 | 96749 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 399X Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1.5x2 | 6003700 | 2103889.2 | 37.7570882837734 | -122.430208878023 | (37.7570882837734, -122.430208878023) | 2 | 4 | 5 | 28862 | 3 | |||
| 10972 | 222690 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1071 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010267.11643 | 2102987.22407 | 37.7549814319516 | -122.407433583719 | (37.7549814319516, -122.407433583719) | 10 | 4 | 7 | 28859 | 19 | |||
| 10977 | 251382 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 731 Huron Ave | 1 | Front Yard : Yard | Tree | Private 2 | 2x5 | 5997668 | 2087467 | 37.7116533538928 | -122.449886244657 | (37.7116533538928, -122.449886244657) | 9 | 7 | 6 | 28861 | 25 | ||||
| 11732 | 261580 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
| 13660 | 71174 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1432 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988368.0802 | 2099689.3718 | 37.7446763519612 | -122.482924085363 | (37.7446763519612, -122.482924085363) | 1 | 8 | 3 | 29491 | 35 | |||
| 14168 | 261582 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
| 15405 | 204726 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 300 Junipero Serra Blvd | 30 | : | Tree | Private 2 | 5 | Width 0ft | 5991392.43358 | 2094433.51883 | 37.7304206284982 | -122.472083541544 | (37.7304206284982, -122.472083541544) | 9 | 8 | 4 | 64 | 40 | |||
| 15575 | 111241 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 745X SANCHEZ ST | 4 | Median : Yard | Tree | DPW 1 | 6 | 6003713 | 2103768 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | 2 | 4 | 5 | 28862 | 3 | ||||
| 16720 | 245107 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 250 Central Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5999850.165 | 2109456.7325 | 37.7721565345872 | -122.443923043844 | (37.7721565345872, -122.443923043844) | 15 | 5 | 11 | 29492 | 9 | |||
| 19115 | 169677 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 15 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6002720.1225 | 2096203.62304 | 37.7359299419005 | -122.433048571547 | (37.7359299419005, -122.433048571547) | 2 | 7 | 5 | 63 | 7 | |||
| 19480 | 261581 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
| 21334 | 125935 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1132 Greenwich St | 2 | Front Yard : Yard | Tree | Private 2 | 9 | 6007463.08276 | 2119890.85277 | 37.8012373932575 | -122.418329199431 | (37.8012373932575, -122.418329199431) | 5 | 1 | 1 | 28858 | 32 | ||||
| 22017 | 204737 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 230 Acadia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001436.76661 | 2095116.79206 | 37.7328728755875 | -122.43740783373 | (37.7328728755875, -122.43740783373) | 9 | 7 | 5 | 63 | 40 | |||
| 24369 | 222679 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 749 Dolores St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 8ft | 6005046.9751 | 2104064.76222 | 37.7576465368663 | -122.425563014118 | (37.7576465368663, -122.425563014118) | 2 | 4 | 5 | 28859 | 19 | |||
| 25880 | 247897 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 351 Mayflower St | 2 | Side Yard : Yard | Tree | Private 2 | 4 | 6010077.88258 | 2098386.84291 | 37.7423392041858 | -122.407763645688 | (37.7423392041858, -122.407763645688) | 10 | 7 | 7 | 28859 | 2 | ||||
| 26624 | 217762 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 470 West Portal Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5991703.40817 | 2096440.7638 | 37.7359500093762 | -122.471154649778 | (37.7359500093762, -122.471154649778) | 1 | 8 | 4 | 29491 | 40 | ||||
| 27938 | 175812 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 15 Athens St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6005342.42292 | 2093158.16241 | 37.7277161800552 | -122.423765749609 | (37.7277161800552, -122.423765749609) | 9 | 7 | 6 | 28861 | 5 | ||||
| 29923 | 116678 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 100 Esmeralda Ave | 17 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
| 30025 | 222683 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1100 San Jose Ave | 27 | Front Yard : Yard | Tree | Private 2 | 4 | 6004834.70298 | 2096673.11166 | 37.7373387712724 | -122.425771027308 | (37.7373387712724, -122.425771027308) | 2 | 7 | 5 | 63 | 7 | ||||
| 30641 | 188411 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 398 Mississippi St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6014024.24871 | 2105357.36092 | 37.7616988910081 | -122.394606216998 | (37.7616988910081, -122.394606216998) | 10 | 3 | 8 | 28856 | 29 | |||
| 32618 | 188410 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1501 22nd St | 23 | Front Yard : Yard | Tree | Private 2 | 15 | 6013292.91596 | 2103788.26891 | 37.7573498217412 | -122.397025598364 | (37.7573498217412, -122.397025598364) | 10 | 3 | 8 | 28856 | 29 | ||||
| 33219 | 175813 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 15 Athens St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6005348.05368 | 2093155.48995 | 37.7277091599291 | -122.423746094022 | (37.7277091599291, -122.423746094022) | 9 | 7 | 6 | 28861 | 5 | ||||
| 34177 | 109402 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1588 WALLER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997977.9 | 2108248 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | 15 | 5 | 11 | 29492 | 9 | ||||
| 35190 | 175803 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 421 Wheeler Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011997.87722 | 2086794.11576 | 37.7106152574533 | -122.400310793023 | (37.7106152574533, -122.400310793023) | 10 | 3 | 8 | 309 | 1 | |||
| 35571 | 175804 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 500x Mansell St | 7 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6010489.90873 | 2090338.00617 | 37.7202618542943 | -122.405772155484 | (37.7202618542943, -122.405772155484) | 10 | 7 | 8 | 309 | 28 | |||
| 37438 | 202043 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 52 Exeter St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6012522.16713 | 2090984.69593 | 37.7221509746816 | -122.398792625891 | (37.7221509746816, -122.398792625891) | 10 | 3 | 8 | 58 | 1 | |||
| 37535 | 122679 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 598x Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008469 | 2098078 | 37.7414009906205 | -122.413304856031 | (37.7414009906205, -122.413304856031) | 2 | 7 | 7 | 28859 | 2 | ||||
| 37756 | 175805 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 35 Ervine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6009673.12409 | 2089221.07256 | 37.7171492746007 | -122.408516774841 | (37.7171492746007, -122.408516774841) | 9 | 7 | 8 | 309 | 39 | |||
| 38633 | 205922 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 370 Monterey Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 5999640.50046 | 2094726.6696 | 37.7316994068856 | -122.443589949734 | (37.7316994068856, -122.443589949734) | 9 | 7 | 4 | 63 | 40 | |||
| 40519 | 222688 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 200 Eugenia Ave | 20 | Front Yard : Yard | Tree | Private 2 | 10 | 6006604.22222 | 2098080.62198 | 37.7413033173982 | -122.419752808255 | (37.7413033173982, -122.419752808255) | 2 | 7 | 7 | 28859 | 2 | ||||
| 41163 | 105989 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 651X Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002337 | 2099724 | 37.745574339333 | -122.434624822764 | (37.745574339333, -122.434624822764) | 2 | 7 | 5 | 63 | 22 | |||||
| 43711 | 222706 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 4218 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001708.51992 | 2101780.94195 | 37.7511865150679 | -122.436945237732 | (37.7511865150679, -122.436945237732) | 2 | 4 | 5 | 28862 | 22 | |||
| 43722 | 96750 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 399X Liberty St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1.5x2 | 6003700 | 2103889.2 | 37.7570882837734 | -122.430208878023 | (37.7570882837734, -122.430208878023) | 2 | 4 | 5 | 28862 | 3 | |||
| 44483 | 22153 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1570X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 3X3 | 6015582.1559258 | 2098251.0940713 | 37.7422730663456 | -122.388721900676 | (37.7422730663456, -122.388721900676) | 10 | 3 | 8 | 58 | 1 | |||
| 45147 | 29574 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400X Junipero Serra Blvd | 7 | Median : Cutout | Tree | DPW 1 | 9 | 3X3 | 5991374.69638 | 2094208.91815 | 37.729802904883 | -122.472128495928 | (37.729802904883, -122.472128495928) | 9 | 8 | 4 | 64 | 40 | |||
| 47914 | 246707 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1 Bonview St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6007720.78655 | 2099148.69396 | 37.744298842209 | -122.415967729029 | (37.744298842209, -122.415967729029) | 2 | 7 | 7 | 28859 | 2 | ||||
| 48397 | 204736 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 40 Vasquez Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995677.52131 | 2100065.80071 | 37.7461325337836 | -122.457676858293 | (37.7461325337836, -122.457676858293) | 1 | 5 | 4 | 59 | 40 | |||
| 48818 | 204713 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1484 16th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 5ft | 5991184.77792 | 2105315.94504 | 37.7602889411076 | -122.473594943052 | (37.7602889411076, -122.473594943052) | 1 | 8 | 4 | 56 | 12 | |||
| 48861 | 175802 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 421 Wheeler Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011992.04716 | 2086775.88516 | 37.7105648747395 | -122.400329663484 | (37.7105648747395, -122.400329663484) | 10 | 3 | 8 | 309 | 1 | |||
| 50589 | 188415 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2 Jennings St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6019090.32903 | 2097590.47628 | 37.7406529492792 | -122.37654576819 | (37.7406529492792, -122.37654576819) | 10 | 3 | 8 | 58 | 1 | |||
| 51409 | 109401 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1588 WALLER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997977.9 | 2108248 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | 15 | 5 | 11 | 29492 | 9 | ||||
| 52701 | 204714 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1484 16th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 5991182.79274 | 2105342.18801 | 37.7603608823676 | -122.473603723127 | (37.7603608823676, -122.473603723127) | 1 | 8 | 4 | 56 | 12 | |||
| 53325 | 188414 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 602 Arthur Ave | 36 | Front Yard : Yard | Tree | Private 2 | 5 | 6015677.9579 | 2099872.41216 | 37.7467301800674 | -122.388503787217 | (37.7467301800674, -122.388503787217) | 3 | 8 | 58 | 1 | |||||
| 54426 | 247973 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 155 Faith St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6010331.53551 | 2099090.76742 | 37.7442862247418 | -122.406936189376 | (37.7442862247418, -122.406936189376) | 2 | 7 | 7 | 28859 | 2 | |||
| 55526 | 222705 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 77 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007841.33022 | 2100005.82897 | 37.7466591201298 | -122.415611588529 | (37.7466591201298, -122.415611588529) | 2 | 7 | 7 | 28859 | 2 | |||
| 55595 | 204727 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 300 Junipero Serra Blvd | 38 | : | Tree | Private 2 | 4 | Width 0ft | 5991391.65527 | 2094396.58957 | 37.73031918497 | -122.472083541538 | (37.73031918497, -122.472083541538) | 9 | 8 | 4 | 64 | 40 | |||
| 55683 | 188417 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 274 Topeka Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013295.80448 | 2094667.84679 | 37.7323072334974 | -122.396376359792 | (37.7323072334974, -122.396376359792) | 10 | 3 | 8 | 58 | 1 | |||
| 57894 | 204735 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 40 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995650.24765 | 2100035.09823 | 37.746046665624 | -122.457768945275 | (37.746046665624, -122.457768945275) | 1 | 5 | 4 | 59 | 40 | |||
| 57947 | 204744 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 545 Melrose Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 5996927.58011 | 2095415.2897 | 37.7334350939589 | -122.453018700168 | (37.7334350939589, -122.453018700168) | 9 | 7 | 4 | 59 | 40 | |||
| 57969 | 222697 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 690 28th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6001460.97341 | 2099432.54018 | 37.7447242889909 | -122.437633112991 | (37.7447242889909, -122.437633112991) | 2 | 7 | 5 | 63 | 22 | |||
| 58479 | 205923 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 266 Judson Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5998304.03576 | 2093569.77611 | 37.7284465374612 | -122.448127087008 | (37.7284465374612, -122.448127087008) | 9 | 7 | 4 | 28861 | 40 | ||||
| 59122 | 204739 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 463 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5998365.55897 | 2095230.78545 | 37.7330107938072 | -122.448033943319 | (37.7330107938072, -122.448033943319) | 9 | 7 | 4 | 59 | 40 | |||
| 59541 | 188409 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2033 22nd St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6011983.90541 | 2103708.46876 | 37.757057753421 | -122.401547091948 | (37.757057753421, -122.401547091948) | 10 | 3 | 8 | 28856 | 29 | |||
| 59676 | 204731 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Junipero Serra Blvd | 25 | : | Tree | Private 2 | 5 | Width 0ft | 5991352.35851 | 2093912.83716 | 37.728988647895 | -122.472184145999 | (37.728988647895, -122.472184145999) | 9 | 8 | 4 | 64 | 40 | |||
| 60197 | 117424 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 600x POWHATTAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008524 | 2098073 | 37.7413903494898 | -122.413114331027 | (37.7413903494898, -122.413114331027) | 10 | 7 | 7 | 28859 | 2 | |||
| 62344 | 204740 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 317 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 5999296.31857 | 2095221.44608 | 37.7330383112512 | -122.44481540373 | (37.7330383112512, -122.44481540373) | 9 | 7 | 4 | 59 | 40 | |||
| 64939 | 188418 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1790 McKinnon Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014392.11707 | 2096695.01257 | 37.7379343616788 | -122.392727888474 | (37.7379343616788, -122.392727888474) | 10 | 3 | 8 | 58 | 1 | |||
| 65409 | 222678 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 749 Dolores St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 6005045.75661 | 2104048.66592 | 37.7576022713581 | -122.425566082603 | (37.7576022713581, -122.425566082603) | 2 | 4 | 5 | 28859 | 19 | |||
| 66830 | 222686 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1201 San Jose Ave | 17 | Front Yard : Yard | Tree | Private 2 | 1 | 6004284.84781 | 2095906.59844 | 37.7352030118052 | -122.427617536921 | (37.7352030118052, -122.427617536921) | 2 | 7 | 5 | 28861 | 2 | ||||
| 66973 | 204729 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Junipero Serra Blvd | 16 | : | Tree | Private 2 | 1 | Width 0ft | 5991368.5463 | 2094108.06034 | 37.7295256186902 | -122.47214240847 | (37.7295256186902, -122.47214240847) | 9 | 8 | 4 | 64 | 40 | |||
| 67118 | 187570 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 73 Bishop St | 1 | Side Yard : Yard | Tree | Private 2 | 6 | 6010859.73078 | 2089462.03095 | 37.7178772802949 | -122.404432169207 | (37.7178772802949, -122.404432169207) | 10 | 7 | 8 | 309 | 39 | ||||
| 68047 | 175814 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 11 Athens St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6005376.33288 | 2093192.89602 | 37.727813465104 | -122.423650990705 | (37.727813465104, -122.423650990705) | 9 | 7 | 6 | 28861 | 5 | ||||
| 73637 | 204718 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1485x Northwood Dr | 6 | Median : Yard | Tree | DPW 1 | 3 | 5995836.31697 | 2094012.72029 | 37.7295213774971 | -122.456690081702 | (37.7295213774971, -122.456690081702) | 9 | 7 | 4 | 28861 | 40 | ||||
| 75024 | 123068 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 678 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992266.69336 | 2110864.34538 | 37.7755859643914 | -122.470257189892 | (37.7755859643914, -122.470257189892) | 11 | 6 | 2 | 54 | 11 | |||
| 75820 | 187575 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 72 Bishop St | 2 | Side Yard : Yard | Tree | Private 2 | 11 | 6010832.96557 | 2089490.79182 | 37.7179547559905 | -122.40452670864 | (37.7179547559905, -122.40452670864) | 10 | 7 | 8 | 309 | 39 | ||||
| 77726 | 105988 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 651X Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002337 | 2099724 | 37.745574339333 | -122.434624822764 | (37.745574339333, -122.434624822764) | 2 | 7 | 5 | 63 | 22 | |||||
| 77966 | 109400 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1588 WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997977.9 | 2108248 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | 15 | 5 | 11 | 29492 | 9 | ||||
| 78784 | 222680 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 76 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6006248.11174 | 2099605.96855 | 37.7454715078156 | -122.421092396098 | (37.7454715078156, -122.421092396098) | 2 | 7 | 5 | 28859 | 2 | |||
| 79994 | 204725 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 300 Junipero Serra Blvd | 29 | : | Tree | Private 2 | 5 | Width 0ft | 5991390.23736 | 2094439.33755 | 37.7304364781515 | -122.472091558075 | (37.7304364781515, -122.472091558075) | 9 | 8 | 4 | 64 | 40 | |||
| 83728 | 123045 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 568 Funston Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5991929.81513 | 2111594.03006 | 37.7775699977667 | -122.471475704283 | (37.7775699977667, -122.471475704283) | 11 | 6 | 2 | 54 | 11 | |||
| 83863 | 204738 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 130 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001200.02257 | 2094962.19919 | 37.7324349372236 | -122.438215245944 | (37.7324349372236, -122.438215245944) | 9 | 7 | 5 | 63 | 40 | |||
| 83930 | 175807 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 156 San Juan Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6001266.11551 | 2092303.88748 | 37.7251395810236 | -122.437796421768 | (37.7251395810236, -122.437796421768) | 9 | 7 | 6 | 28861 | 25 | |||
| 86172 | 188399 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 619 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010997.55787 | 2105333.97174 | 37.7614659351153 | -122.405072728445 | (37.7614659351153, -122.405072728445) | 10 | 3 | 8 | 28856 | 29 | |||
| 87025 | 175799 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1500 San Jose Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 6001536.44317 | 2094235.33238 | 37.7304582561421 | -122.43700014314 | (37.7304582561421, -122.43700014314) | 9 | 7 | 6 | 28861 | 25 | |||
| 88080 | 15071 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1X Minerva St | 3 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5995959.85959 | 2089005.66859 | 37.7157802951115 | -122.455901163122 | (37.7157802951115, -122.455901163122) | 9 | 8 | 6 | 28861 | 24 | |||
| 88659 | 204716 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 155 Madrone Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992699.21388 | 2098207.72713 | 37.7408591943976 | -122.467840257748 | (37.7408591943976, -122.467840257748) | 1 | 8 | 4 | 59 | 40 | |||
| 89239 | 248046 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 38 Rutledge St | 3 | Side Yard : Yard | Tree | Private 2 | 4 | 6010555.40468 | 2099417.48898 | 37.745195855722 | -122.406185107956 | (37.745195855722, -122.406185107956) | 2 | 7 | 7 | 28859 | 2 | ||||
| 90395 | 122681 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 598x Powhattan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008469 | 2098078 | 37.7414009906205 | -122.413304856031 | (37.7414009906205, -122.413304856031) | 2 | 7 | 7 | 28859 | 2 | ||||
| 91616 | 109399 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1588 WALLER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997977.9 | 2108248 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | 15 | 5 | 11 | 29492 | 9 | ||||
| 92867 | 175806 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 154 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010320.93963 | 2087695.47295 | 37.7129965480265 | -122.406170150427 | (37.7129965480265, -122.406170150427) | 9 | 7 | 8 | 309 | 39 | |||
| 94221 | 222692 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 501 York St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6009835.71539 | 2105907.76012 | 37.7629764094606 | -122.409131567579 | (37.7629764094606, -122.409131567579) | 8 | 4 | 8 | 28859 | 19 | |||
| 99176 | 222684 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1100 San Jose Ave | 28 | Front Yard : Yard | Tree | Private 2 | 4 | 6004829.85448 | 2096667.61167 | 37.7373233955514 | -122.425787399465 | (37.7373233955514, -122.425787399465) | 2 | 7 | 5 | 63 | 7 | ||||
| 100784 | 204742 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 933 Teresita Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 5998605.5734 | 2095661.21413 | 37.7342063660283 | -122.447235121417 | (37.7342063660283, -122.447235121417) | 9 | 7 | 4 | 59 | 40 | |||
| 104858 | 222682 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2 Trainor St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008292.27538 | 2108046.95875 | 37.7687635657167 | -122.414621202905 | (37.7687635657167, -122.414621202905) | 8 | 4 | 7 | 28853 | 19 | |||
| 105081 | 97214 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 300X Claremont Blvd | 1 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 12 | 5993486 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | 1 | 8 | 4 | 59 | 40 | ||||
| 105681 | 204720 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 60 Agua Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5997138.08387 | 2098588.27013 | 37.7421593919444 | -122.452519836329 | (37.7421593919444, -122.452519836329) | 9 | 7 | 4 | 59 | 40 | |||
| 105708 | 188400 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1045 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6015554.8451 | 2104260.21833 | 37.7587713477501 | -122.389235841663 | (37.7587713477501, -122.389235841663) | 10 | 3 | 8 | 28856 | 29 | |||
| 106412 | 175800 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 701 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6001959.22027 | 2089802.64954 | 37.7183111303438 | -122.435221609694 | (37.7183111303438, -122.435221609694) | 9 | 7 | 6 | 28861 | 5 | |||
| 106694 | 204743 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 280 Joost Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 7ft | 6000165.05205 | 2094974.54581 | 37.732409919872 | -122.441794258103 | (37.732409919872, -122.441794258103) | 9 | 7 | 5 | 63 | 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) );