trees
3,267 rows where qSpecies_id = 67 sorted by Longitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 141981 | 18789 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Rosie Lee Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6018114.760056 | 2094395.2295851 | 37.7318256648951 | -122.379697013742 | (37.7318256648951, -122.379697013742) | 10 | 3 | 8 | 58 | 1 | |||
| 34680 | 4896 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Rosie Lee Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/11/1999 12:00:00 AM | 6 | 3X4 | 6018106.77773 | 2094390.54536 | 37.7318123626362 | -122.379724285267 | (37.7318123626362, -122.379724285267) | 10 | 3 | 8 | 58 | 1 | ||
| 180093 | 4897 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Rosie Lee Ln | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6018099.28954 | 2094405.02636 | 37.731851711586 | -122.37975117949 | (37.731851711586, -122.37975117949) | 10 | 3 | 8 | 58 | 1 | |||
| 30687 | 188268 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 75 Beatrice Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6018091.56 | 2094271.94508 | 37.7314858700568 | -122.379768659608 | (37.7314858700568, -122.379768659608) | 10 | 3 | 8 | 58 | 1 | |||
| 138597 | 188266 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 9 Navy Rd | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6018074.33224 | 2093577.43791 | 37.7295779385535 | -122.379779984755 | (37.7295779385535, -122.379779984755) | 10 | 3 | 8 | 58 | 1 | |||
| 20911 | 188282 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 11 Rosie Lee Ln | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6018083.14168 | 2094370.92156 | 37.731757175754 | -122.379804637898 | (37.731757175754, -122.379804637898) | 10 | 3 | 8 | 58 | 1 | |||
| 78124 | 1875 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Beatrice Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6018011.4321332 | 2094063.1260405 | 37.7309080736078 | -122.380031174991 | (37.7309080736078, -122.380031174991) | 10 | 3 | 8 | 58 | 1 | |||
| 37266 | 4898 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Rosie Lee Ln | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017985.0017 | 2094485.55993 | 37.7320665362465 | -122.380151894906 | (37.7320665362465, -122.380151894906) | 10 | 3 | 8 | 58 | 1 | |||
| 114808 | 6392 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Espanola St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017974.4315502 | 2094113.8790238 | 37.7310453900638 | -122.380162619042 | (37.7310453900638, -122.380162619042) | 10 | 3 | 8 | 58 | 1 | |||
| 80972 | 188277 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Beatrice Ln | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017947.76694 | 2094045.54207 | 37.7308562789814 | -122.380250056804 | (37.7308562789814, -122.380250056804) | 10 | 3 | 8 | 58 | 1 | |||
| 42689 | 188281 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 11 Rosie Lee Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017931.86479 | 2094462.1595 | 37.7319993514708 | -122.380333977027 | (37.7319993514708, -122.380333977027) | 10 | 3 | 8 | 58 | 1 | |||
| 146208 | 188276 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Beatrice Ln | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6017913.92599 | 2094045.4475 | 37.7308541521008 | -122.380367045109 | (37.7308541521008, -122.380367045109) | 10 | 3 | 8 | 58 | 1 | |||
| 89334 | 18800 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Rosie Lee Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017918.7507593 | 2094507.5509584 | 37.732123263915 | -122.380382469104 | (37.732123263915, -122.380382469104) | 10 | 3 | 8 | 58 | 1 | |||
| 28630 | 1883 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 31 Beatrice Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017903.7063488 | 2094083.9229995 | 37.7309592343941 | -122.380405049514 | (37.7309592343941, -122.380405049514) | 10 | 3 | 8 | 58 | 1 | |||
| 28561 | 188269 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Rosie Lee Ln | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6017903.32503 | 2094505.01761 | 37.7321154566611 | -122.380435623808 | (37.7321154566611, -122.380435623808) | 10 | 3 | 8 | 58 | 1 | |||
| 117115 | 18806 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 54 Rosie Lee Ln | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X4 | 6017853.0028401 | 2094472.3604 | 37.7320230094763 | -122.380607331399 | (37.7320230094763, -122.380607331399) | 10 | 3 | 8 | 58 | 1 | |||
| 133897 | 18805 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 54 Rosie Lee Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017853.0028401 | 2094472.3604 | 37.7320230094763 | -122.380607331399 | (37.7320230094763, -122.380607331399) | 10 | 3 | 8 | 58 | 1 | |||
| 180749 | 188275 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Beatrice Ln | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6017837.50464 | 2094055.50423 | 37.7308775488575 | -122.380631947623 | (37.7308775488575, -122.380631947623) | 10 | 3 | 8 | 58 | 1 | |||
| 167470 | 1885 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 47 Beatrice Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017815.3331022 | 2094109.8571584 | 37.7310255677831 | -122.380712375821 | (37.7310255677831, -122.380712375821) | 10 | 3 | 8 | 58 | 1 | |||
| 170599 | 1887 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 47 Beatrice Ln | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017815.3331022 | 2094109.8571584 | 37.7310255677831 | -122.380712375821 | (37.7310255677831, -122.380712375821) | 10 | 3 | 8 | 58 | 1 | |||
| 172584 | 1886 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 47 Beatrice Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017815.3331022 | 2094109.8571584 | 37.7310255677831 | -122.380712375821 | (37.7310255677831, -122.380712375821) | 10 | 3 | 8 | 58 | 1 | |||
| 156418 | 188280 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 12 Lillian St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6017796.93346 | 2094324.7108 | 37.7316144983135 | -122.380790917192 | (37.7316144983135, -122.380790917192) | 10 | 3 | 8 | 58 | 1 | |||
| 126615 | 188274 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Beatrice Ln | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6017787.78599 | 2094078.1936 | 37.7309371055483 | -122.380805411565 | (37.7309371055483, -122.380805411565) | 10 | 3 | 8 | 58 | 1 | |||
| 71405 | 1879 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45X Lillian St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/12/2003 12:00:00 AM | 12 | 3X4 | 6017774.309035 | 2094355.975399 | 37.7316990960952 | -122.380871307769 | (37.7316990960952, -122.380871307769) | 10 | 3 | 8 | 58 | 1 | ||
| 135039 | 1881 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45X Lillian St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X4 | 6017774.309035 | 2094355.975399 | 37.7316990960952 | -122.380871307769 | (37.7316990960952, -122.380871307769) | 10 | 3 | 8 | 58 | 1 | |||
| 153943 | 1890 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 50 Beatrice Ln | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X4 | 6017765.907514 | 2094082.2550294 | 37.7309470499267 | -122.380881332108 | (37.7309470499267, -122.380881332108) | 10 | 3 | 8 | 58 | 1 | |||
| 135760 | 188273 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Beatrice Ln | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6017757.59248 | 2094104.75072 | 37.7310083597514 | -122.380911642168 | (37.7310083597514, -122.380911642168) | 10 | 3 | 8 | 58 | 1 | |||
| 135531 | 188279 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 12 Lillian St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017754.54552 | 2094265.39597 | 37.7314492919381 | -122.380933340095 | (37.7314492919381, -122.380933340095) | 10 | 3 | 8 | 58 | 1 | |||
| 113541 | 18812 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Rosie Lee Ln | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017743.9455674 | 2094518.0196352 | 37.7321423618577 | -122.380987543086 | (37.7321423618577, -122.380987543086) | 10 | 3 | 8 | 58 | 1 | |||
| 99472 | 188278 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 12 Lillian St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6017724.20983 | 2094242.07575 | 37.7313835847835 | -122.381036596687 | (37.7313835847835, -122.381036596687) | 10 | 3 | 8 | 58 | 1 | |||
| 55242 | 188270 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Rosie Lee Ln | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6017725.6269 | 2094584.88968 | 37.7323249627215 | -122.381055522912 | (37.7323249627215, -122.381055522912) | 10 | 3 | 8 | 58 | 1 | |||
| 1578 | 10783 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1200X Hudson Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x4 | 6017715.9911991 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | 10 | 3 | 8 | 58 | 1 | |||
| 10973 | 10788 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1200X Hudson Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x4 | 6017715.9911991 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | 10 | 3 | 8 | 58 | 1 | |||
| 35428 | 10789 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1200X Hudson Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x4 | 6017715.9911991 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | 10 | 3 | 8 | 58 | 1 | |||
| 192975 | 1894 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 79 Beatrice Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017701.0374377 | 2094273.2748059 | 37.7314679721847 | -122.381118877186 | (37.7314679721847, -122.381118877186) | 10 | 3 | 8 | 58 | 1 | |||
| 163711 | 188272 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Beatrice Ln | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6017665.18673 | 2094248.36681 | 37.7313976007006 | -122.381241089926 | (37.7313976007006, -122.381241089926) | 10 | 3 | 8 | 58 | 1 | |||
| 158311 | 1876 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Beatrice Ln | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017644.79908 | 2094278.98738 | 37.7314805532838 | -122.381313702976 | (37.7314805532838, -122.381313702976) | 10 | 3 | 8 | 58 | 1 | |||
| 138213 | 1898 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 95 Beatrice Ln | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017638.1071524 | 2094354.0127634 | 37.7316861888132 | -122.381342053504 | (37.7316861888132, -122.381342053504) | 10 | 3 | 8 | 58 | 1 | |||
| 180107 | 1899 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 95 Beatrice Ln | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017638.1071524 | 2094354.0127634 | 37.7316861888132 | -122.381342053504 | (37.7316861888132, -122.381342053504) | 10 | 3 | 8 | 58 | 1 | |||
| 81999 | 188271 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Beatrice Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6017623.68849 | 2094312.33343 | 37.7315709495417 | -122.381389005013 | (37.7315709495417, -122.381389005013) | 10 | 3 | 8 | 58 | 1 | |||
| 141001 | 10874 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1175X Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | |||
| 170151 | 10875 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1175X Hudson Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/03/1991 12:00:00 AM | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | ||
| 183819 | 10880 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1175X Hudson Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | |||
| 188377 | 10883 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1175X Hudson Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | |||
| 31212 | 108029 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1308 Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6017326.2062 | 2092992.2495 | 37.7279298303143 | -122.382325662572 | (37.7279298303143, -122.382325662572) | 10 | 3 | 8 | 58 | 1 | |||
| 77427 | 10850 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1220X Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017356.4574634 | 2095156.0177673 | 37.7338727832056 | -122.382371560842 | (37.7338727832056, -122.382371560842) | 10 | 3 | 8 | 58 | 1 | |||
| 22678 | 199908 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1216 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6017309.9205 | 2093127.3901 | 37.7283000004206 | -122.382391361643 | (37.7283000004206, -122.382391361643) | 10 | 3 | 8 | 58 | 1 | |||
| 74011 | 188262 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1322 Hudson Ave | 47 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017323.3407 | 2095203.17011 | 37.7340004248815 | -122.38248933632 | (37.7340004248815, -122.38248933632) | 10 | 3 | 8 | 58 | 1 | |||
| 28525 | 188261 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1339 Hudson Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6017310.47324 | 2095140.94746 | 37.7338288630114 | -122.382529495567 | (37.7338288630114, -122.382529495567) | 10 | 3 | 8 | 58 | 1 | |||
| 153655 | 188260 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1339 Hudson Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017298.63225 | 2095158.35952 | 37.7338760189594 | -122.382571644977 | (37.7338760189594, -122.382571644977) | 10 | 3 | 8 | 58 | 1 | |||
| 181803 | 122801 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1219 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6017253.657 | 2093097.6354 | 37.7282151918398 | -122.382583799411 | (37.7282151918398, -122.382583799411) | 10 | 3 | 8 | 58 | 1 | |||
| 7769 | 199923 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1398 Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6017238.3952 | 2092867.7981 | 37.7275832604461 | -122.382620574427 | (37.7275832604461, -122.382620574427) | 10 | 3 | 8 | 58 | 1 | |||
| 139264 | 188259 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1339 Hudson Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017275.09944 | 2095200.58275 | 37.7339906555386 | -122.382655942916 | (37.7339906555386, -122.382655942916) | 10 | 3 | 8 | 58 | 1 | |||
| 84255 | 188263 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1322 Hudson Ave | 52 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017270.30063 | 2095300.86237 | 37.7342657383686 | -122.382679509676 | (37.7342657383686, -122.382679509676) | 10 | 3 | 8 | 58 | 1 | |||
| 54030 | 10885 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1270X Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1997 12:00:00 AM | 6 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | ||
| 58006 | 10893 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1270X Hudson Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | |||
| 147960 | 10892 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1270X Hudson Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | |||
| 148501 | 10886 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1270X Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1999 12:00:00 AM | 6 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | ||
| 184439 | 10891 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1270X Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | |||
| 10420 | 105551 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1398X HAWES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6017214 | 2092838 | 37.7275000929711 | -122.382702837059 | (37.7275000929711, -122.382702837059) | 10 | 3 | 8 | 58 | 1 | |||
| 106792 | 188264 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1322 Hudson Ave | 53 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017261.07145 | 2095318.28053 | 37.7343130553028 | -122.382712629894 | (37.7343130553028, -122.382712629894) | 10 | 3 | 8 | 58 | 1 | |||
| 168064 | 105549 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1200 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6017207.7562 | 2092857.3745 | 37.7275529466122 | -122.382725769768 | (37.7275529466122, -122.382725769768) | 10 | 3 | 8 | 58 | 1 | |||
| 44911 | 105550 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1200 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6017193.2263 | 2092868.7457 | 37.7275833669602 | -122.382776791229 | (37.7275833669602, -122.382776791229) | 10 | 3 | 8 | 58 | 1 | |||
| 45611 | 199968 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400 Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6017172.3791 | 2092782.1982 | 37.7273445726468 | -122.382842840519 | (37.7273445726468, -122.382842840519) | 10 | 3 | 8 | 58 | 1 | |||
| 59405 | 188258 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1339 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017221.78678 | 2095299.66374 | 37.7342597668734 | -122.382847155894 | (37.7342597668734, -122.382847155894) | 10 | 3 | 8 | 58 | 1 | |||
| 145586 | 199918 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1208 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6017172.7159 | 2092880.7849 | 37.7276152910588 | -122.382848534061 | (37.7276152910588, -122.382848534061) | 10 | 3 | 8 | 58 | 1 | |||
| 107964 | 103999 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1201 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6017169.9617 | 2092803.1151 | 37.727401872803 | -122.382852652572 | (37.727401872803, -122.382852652572) | 10 | 3 | 8 | 58 | 1 | |||
| 131733 | 199974 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1415 Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6017164.7983 | 2092702.5998 | 37.7271255921495 | -122.382863510542 | (37.7271255921495, -122.382863510542) | 10 | 3 | 8 | 58 | 1 | |||
| 83983 | 199969 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400 Hawes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6017155.9541 | 2092761.9827 | 37.7272881573332 | -122.382898216023 | (37.7272881573332, -122.382898216023) | 10 | 3 | 8 | 58 | 1 | |||
| 100530 | 199919 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1208 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6017156.1904 | 2092897.3103 | 37.7276597535169 | -122.382906813046 | (37.7276597535169, -122.382906813046) | 10 | 3 | 8 | 58 | 1 | |||
| 92463 | 111565 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400x HAWES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017154 | 2092794 | 37.7273759626121 | -122.382907198656 | (37.7273759626121, -122.382907198656) | 10 | 3 | 8 | 58 | 1 | ||||
| 95331 | 111566 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400x HAWES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017154 | 2092794 | 37.7273759626121 | -122.382907198656 | (37.7273759626121, -122.382907198656) | 10 | 3 | 8 | 58 | 1 | ||||
| 108884 | 111564 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400x HAWES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017154 | 2092794 | 37.7273759626121 | -122.382907198656 | (37.7273759626121, -122.382907198656) | 10 | 3 | 8 | 58 | 1 | ||||
| 100390 | 199970 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400 Hawes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6017142.6877 | 2092741.1355 | 37.7272301819921 | -122.382942628131 | (37.7272301819921, -122.382942628131) | 10 | 3 | 8 | 58 | 1 | |||
| 39661 | 103997 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1410X Hawes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6017134.59054 | 2092698.10151 | 37.7271115716676 | -122.38296762653 | (37.7271115716676, -122.38296762653) | 10 | 3 | 8 | 58 | 1 | |||
| 84748 | 103998 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1410X Hawes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6017134.59054 | 2092698.10151 | 37.7271115716676 | -122.38296762653 | (37.7271115716676, -122.38296762653) | 10 | 3 | 8 | 58 | 1 | |||
| 92814 | 103995 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1410X Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6017134.59054 | 2092698.10151 | 37.7271115716676 | -122.38296762653 | (37.7271115716676, -122.38296762653) | 10 | 3 | 8 | 58 | 1 | |||
| 180005 | 103996 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1410X Hawes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6017134.59054 | 2092698.10151 | 37.7271115716676 | -122.38296762653 | (37.7271115716676, -122.38296762653) | 10 | 3 | 8 | 58 | 1 | |||
| 124316 | 188265 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1328 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017184.66383 | 2095498.60443 | 37.7348039673342 | -122.382989344098 | (37.7348039673342, -122.382989344098) | 10 | 3 | 8 | 58 | 1 | |||
| 119607 | 111567 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400x Hawes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6017125.6309 | 2092720.9201 | 37.727173731995 | -122.38300018763 | (37.727173731995, -122.38300018763) | 10 | 3 | 8 | 58 | 1 | |||
| 75121 | 199914 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1220 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6017119.8344 | 2092922.0985 | 37.7277258082427 | -122.38303422196 | (37.7277258082427, -122.38303422196) | 10 | 3 | 8 | 58 | 1 | |||
| 151316 | 199946 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1215 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6017105.5123 | 2092851.5899 | 37.7275314140336 | -122.383078828854 | (37.7275314140336, -122.383078828854) | 10 | 3 | 8 | 58 | 1 | |||
| 159030 | 10904 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1336 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6017110.58947 | 2095748.73218 | 37.7354866750771 | -122.38326285221 | (37.7354866750771, -122.38326285221) | 10 | 3 | 8 | 58 | 1 | |||
| 39937 | 10905 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1336 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6017099.8174 | 2095796.95321 | 37.73561848511 | -122.383303451209 | (37.73561848511, -122.383303451209) | 10 | 3 | 8 | 58 | 1 | |||
| 29201 | 199977 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1221 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6016917.6728 | 2092649.1528 | 37.7269651801144 | -122.383714109339 | (37.7269651801144, -122.383714109339) | 10 | 3 | 8 | 58 | 1 | |||
| 111247 | 199955 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1226 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016917.6728 | 2092728.4751 | 37.7271829836155 | -122.383719629667 | (37.7271829836155, -122.383719629667) | 10 | 3 | 8 | 58 | 1 | |||
| 98986 | 199916 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1255 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6016905.5541 | 2092999.2174 | 37.7279257189991 | -122.383780366921 | (37.7279257189991, -122.383780366921) | 10 | 3 | 8 | 58 | 1 | |||
| 190364 | 199949 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1234 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016872.5031 | 2092757.6701 | 37.7272606504521 | -122.383877814405 | (37.7272606504521, -122.383877814405) | 10 | 3 | 8 | 58 | 1 | |||
| 85612 | 199956 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1238 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6016851.5709 | 2092773.0939 | 37.7273018440116 | -122.38395125115 | (37.7273018440116, -122.38395125115) | 10 | 3 | 8 | 58 | 1 | |||
| 177438 | 199973 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1241 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6016820.1725 | 2092720.7632 | 37.7271564183257 | -122.384056153817 | (37.7271564183257, -122.384056153817) | 10 | 3 | 8 | 58 | 1 | |||
| 88170 | 59679 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1246 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1981 12:00:00 AM | 7 | Permit Number 19105 | 6016818.5199 | 2092798.4329 | 37.7273695927226 | -122.384067273223 | (37.7273695927226, -122.384067273223) | 10 | 3 | 8 | 58 | 1 | ||
| 189890 | 199906 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1280 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6016815.2148 | 2093150.1501 | 37.728335156345 | -122.384103181463 | (37.728335156345, -122.384103181463) | 10 | 3 | 8 | 58 | 1 | |||
| 61950 | 199932 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1250 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016791.5283 | 2092818.2635 | 37.7274225513541 | -122.384161964499 | (37.7274225513541, -122.384161964499) | 10 | 3 | 8 | 58 | 1 | |||
| 54321 | 199907 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1280 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016798.1385 | 2093163.3704 | 37.7283705125696 | -122.38416313585 | (37.7283705125696, -122.38416313585) | 10 | 3 | 8 | 58 | 1 | |||
| 192395 | 102739 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1249 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016779.4097 | 2092749.4074 | 37.7272328159816 | -122.384199065737 | (37.7272328159816, -122.384199065737) | 10 | 3 | 8 | 58 | 1 | |||
| 78023 | 199931 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1254 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016771.1469 | 2092830.933 | 37.7274562124229 | -122.38423330569 | (37.7274562124229, -122.38423330569) | 10 | 3 | 8 | 58 | 1 | |||
| 71044 | 199926 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1258 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6016753.5197 | 2092848.5602 | 37.7275036386073 | -122.384295470701 | (37.7275036386073, -122.384295470701) | 10 | 3 | 8 | 58 | 1 | |||
| 24630 | 199971 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1255 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6016740.2994 | 2092779.7041 | 37.7273138422776 | -122.384336380249 | (37.7273138422776, -122.384336380249) | 10 | 3 | 8 | 58 | 1 | |||
| 158245 | 199924 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1262 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6016730.9349 | 2092862.3314 | 37.727540202809 | -122.384374505972 | (37.727540202809, -122.384374505972) | 10 | 3 | 8 | 58 | 1 | |||
| 119610 | 199922 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1266 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6016715.5112 | 2092875.0009 | 37.7275741378954 | -122.384428708392 | (37.7275741378954, -122.384428708392) | 10 | 3 | 8 | 58 | 1 |
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) );