trees
412 rows where qSpecies_id = 216 sorted by Zip Codes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10913 | 253391 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2529x Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 11553 | 221666 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 599 Buchanan St | 5 | : | Tree | Private 2 | 1 | Width 6ft | 6004540.01666 | 2110455.77622 | 37.7751660677958 | -122.427771645646 | (37.7751660677958, -122.427771645646) | 7 | 9 | 11 | 28852 | 10 | |||
| 32265 | 221667 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 513 Hickory St | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6004344.86281 | 2110297.09117 | 37.7747193160817 | -122.428435413676 | (37.7747193160817, -122.428435413676) | 7 | 9 | 11 | 28852 | 10 | |||
| 34521 | 245847 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 253 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005116.227 | 2109828.8135 | 37.7734771588527 | -122.425733769016 | (37.7734771588527, -122.425733769016) | 7 | 9 | 11 | 28852 | 10 | |||
| 36733 | 221665 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 415 Buchanan St | 2 | : | Tree | Private 2 | 1 | Width 6ft | 6004608.71317 | 2109961.56798 | 37.7738129784269 | -122.427498793141 | (37.7738129784269, -122.427498793141) | 7 | 9 | 11 | 28852 | 10 | |||
| 103513 | 221680 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 482 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004683.99616 | 2110372.61321 | 37.7749458660929 | -122.427267662885 | (37.7749458660929, -122.427267662885) | 7 | 9 | 11 | 28852 | 10 | |||
| 130574 | 221679 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 308 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004979.97229 | 2109899.22252 | 37.7736627844387 | -122.426210107812 | (37.7736627844387, -122.426210107812) | 7 | 9 | 11 | 28852 | 10 | |||
| 63903 | 220401 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 65 McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6006279.41971 | 2109112.41341 | 37.7715757574385 | -122.421659217195 | (37.7715757574385, -122.421659217195) | 8 | 2 | 9 | 28853 | 19 | |||
| 90862 | 221673 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 53 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006500.29072 | 2108193.70634 | 37.7690656587778 | -122.420829975738 | (37.7690656587778, -122.420829975738) | 8 | 4 | 7 | 28853 | 19 | |||
| 107733 | 221664 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 65 McCoppin St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6006280.59621 | 2109108.90891 | 37.7715662012613 | -122.421654898657 | (37.7715662012613, -122.421654898657) | 8 | 2 | 9 | 28853 | 19 | |||
| 32124 | 120500 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 50X Ecker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778820 | 6013077.52006 | 2115450.9456 | 37.7893609031295 | -122.398588915951 | (37.7893609031295, -122.398588915951) | 12 | 2 | 9 | 28855 | 6 | |
| 42310 | 120499 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 50X Ecker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778820 | 6013067.81097 | 2115461.47291 | 37.7893892677417 | -122.398623247559 | (37.7893892677417, -122.398623247559) | 12 | 2 | 9 | 28855 | 6 | |
| 51986 | 120502 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 50X Ecker St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778820 | 6013100.31596 | 2115425.92976 | 37.7892934854631 | -122.398508288148 | (37.7892934854631, -122.398508288148) | 12 | 2 | 9 | 28855 | 6 | |
| 69550 | 187839 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2 Anthony St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 6012618.54939 | 2115295.68448 | 37.7889090117828 | -122.400166003066 | (37.7889090117828, -122.400166003066) | 12 | 2 | 9 | 28855 | 6 | |||
| 77266 | 187844 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2 Anthony St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6012639.88234 | 2115272.52164 | 37.7888466015242 | -122.400090566143 | (37.7888466015242, -122.400090566143) | 12 | 2 | 9 | 28855 | 6 | |||
| 114524 | 120501 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 50X Ecker St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778820 | 6013088.10367 | 2115439.05309 | 37.7893288387076 | -122.398551462773 | (37.7893288387076, -122.398551462773) | 12 | 2 | 9 | 28855 | 6 | |
| 158447 | 187841 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2 Anthony St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6012627.24493 | 2115287.70514 | 37.7888875872319 | -122.400135356873 | (37.7888875872319, -122.400135356873) | 12 | 2 | 9 | 28855 | 6 | |||
| 164905 | 120498 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 50X Ecker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778820 | 6013051.90851 | 2115477.96446 | 37.7894336636916 | -122.398679426422 | (37.7894336636916, -122.398679426422) | 12 | 2 | 9 | 28855 | 6 | |
| 184222 | 187843 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2 Anthony St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6012635.2526 | 2115279.40045 | 37.7888652309851 | -122.400107067789 | (37.7888652309851, -122.400107067789) | 12 | 2 | 9 | 28855 | 6 | |||
| 190025 | 187842 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2 Anthony St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6012630.56089 | 2115283.22761 | 37.788875477874 | -122.40012356945 | (37.788875477874, -122.40012356945) | 12 | 2 | 9 | 28855 | 6 | |||
| 192953 | 187840 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2 Anthony St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 6012623.23421 | 2115291.51814 | 37.7888978332071 | -122.4001495014 | (37.7888978332071, -122.4001495014) | 12 | 2 | 9 | 28855 | 6 | |||
| 8727 | 187834 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1751 22nd St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6012872.98936 | 2103757.51384 | 37.7572419903395 | -122.398475721873 | (37.7572419903395, -122.398475721873) | 10 | 3 | 8 | 28856 | 29 | |||
| 11045 | 187828 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1989 18th St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6011906.05073 | 2105571.23226 | 37.7621681446677 | -122.401947288436 | (37.7621681446677, -122.401947288436) | 10 | 3 | 8 | 28856 | 29 | |||
| 13424 | 83116 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 625 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52391 | 6012731.81298 | 2104419.00109 | 37.7590504235551 | -122.399010395827 | (37.7590504235551, -122.399010395827) | 10 | 3 | 8 | 28856 | 29 | |
| 24299 | 187821 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1100 26th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 7ft | 6015077.55547 | 2101606.98896 | 37.751459673338 | -122.390701131346 | (37.751459673338, -122.390701131346) | 10 | 3 | 8 | 28856 | 1 | |||
| 38755 | 110656 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 500 De Haro St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2015 12:00:00 AM | 3 | 3x3 | 6012024.49835 | 2106000.36066 | 37.7633530455212 | -122.40156778264 | (37.7633530455212, -122.40156778264) | 8 | 3 | 8 | 28856 | 29 | |
| 44089 | 187825 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 800 19th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 6015084.69781 | 2105339.12004 | 37.761707704374 | -122.390937245672 | (37.761707704374, -122.390937245672) | 10 | 3 | 8 | 28856 | 29 | |||
| 44604 | 187820 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 566 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011198.96482 | 2105703.6137 | 37.7624921461136 | -122.404402160644 | (37.7624921461136, -122.404402160644) | 8 | 3 | 8 | 28856 | 29 | |||
| 48357 | 187826 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 800 19th St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 10ft | 6015000.54682 | 2105330.7692 | 37.761680105077 | -122.391227708704 | (37.761680105077, -122.391227708704) | 10 | 3 | 8 | 28856 | 29 | |||
| 56910 | 187832 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 848 Kansas St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 6011545.77845 | 2104374.67474 | 37.7588625506898 | -122.403109170265 | (37.7588625506898, -122.403109170265) | 10 | 3 | 8 | 28856 | 29 | |||
| 85991 | 187822 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 651 Indiana St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6014933.77995 | 2105442.46468 | 37.7619830911575 | -122.391466439131 | (37.7619830911575, -122.391466439131) | 10 | 3 | 8 | 28856 | 29 | |||
| 87027 | 187827 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1776 18th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 2ft | 6012462.11 | 2105661.6775 | 37.7624475055702 | -122.400030431159 | (37.7624475055702, -122.400030431159) | 14 | 3 | 8 | 28856 | 29 | |||
| 92994 | 187830 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 500 De Haro St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6012020.68344 | 2105975.58069 | 37.7632847923835 | -122.40157923552 | (37.7632847923835, -122.40157923552) | 8 | 3 | 8 | 28856 | 29 | ||||
| 96211 | 51795 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1023 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52392 | 6011949.33293 | 2103395.35355 | 37.7561960787909 | -122.401644650401 | (37.7561960787909, -122.401644650401) | 10 | 3 | 8 | 28856 | 29 | |
| 98694 | 187833 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 848 Kansas St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 6011546.21827 | 2104357.82851 | 37.7588163192433 | -122.403106464191 | (37.7588163192433, -122.403106464191) | 10 | 3 | 8 | 28856 | 29 | |||
| 99740 | 187823 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 654 Minnesota St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 10ft | 6015142.96332 | 2105500.9712 | 37.7621553455266 | -122.390747038169 | (37.7621553455266, -122.390747038169) | 10 | 3 | 8 | 28856 | 29 | |||
| 103629 | 187835 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 514 Connecticut St | 2 | : | Tree | Private 2 | 2 | Width 3ft | 6013228.65478 | 2104513.98611 | 37.759338905384 | -122.397298730545 | (37.759338905384, -122.397298730545) | 10 | 3 | 8 | 28856 | 29 | |||
| 111957 | 80118 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 625 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52391 | 6012721.58801903 | 2104578.90179473 | 37.7594889059642 | -122.399056982327 | (37.7594889059642, -122.399056982327) | 10 | 3 | 8 | 28856 | 29 | ||
| 157003 | 61580 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 660 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/1993 12:00:00 AM | 10 | Permit Number 31997 | 6012675.50782 | 2104387.47055 | 37.7589607098827 | -122.399202913691 | (37.7589607098827, -122.399202913691) | 10 | 3 | 8 | 28856 | 29 | |
| 169786 | 187829 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 500 De Haro St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6012022.35521 | 2105982.64886 | 37.7633042932852 | -122.401573950187 | (37.7633042932852, -122.401573950187) | 8 | 3 | 8 | 28856 | 29 | ||||
| 177101 | 96784 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 615 Rhode Island St | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/19/2011 12:00:00 AM | Permit Number 767987 | 6011854.6 | 2105476.9 | 37.7619062576766 | -122.402118605761 | (37.7619062576766, -122.402118605761) | 10 | 3 | 8 | 28856 | 29 | ||||
| 178804 | 187824 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 654 Minnesota St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 6015152.23772 | 2105353.21099 | 37.7617501424761 | -122.390704635107 | (37.7617501424761, -122.390704635107) | 10 | 3 | 8 | 28856 | 29 | |||
| 188948 | 187831 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 500 De Haro St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6012023.10587 | 2105969.444 | 37.7632680775732 | -122.40157042575 | (37.7632680775732, -122.40157042575) | 8 | 3 | 8 | 28856 | 29 | ||||
| 2115 | 125373 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2820 Van Ness Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 6005714.14628 | 2120095.1224 | 37.8016996609768 | -122.424395829926 | (37.8016996609768, -122.424395829926) | 5 | 9 | 1 | 28858 | 32 | |||
| 6760 | 125377 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 12 Hastings Ter | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6007265.71276 | 2119272.51381 | 37.7995284781148 | -122.418968306241 | (37.7995284781148, -122.418968306241) | 5 | 1 | 1 | 28858 | 32 | ||||
| 23469 | 125395 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2671 Leavenworth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 6007309.27771 | 2121901.08627 | 37.8067483254418 | -122.419004095666 | (37.8067483254418, -122.419004095666) | 5 | 1 | 1 | 28858 | 32 | |||
| 67910 | 125378 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 16 Havens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6007605.55128 | 2119392.07825 | 37.7998759024036 | -122.41780081986 | (37.7998759024036, -122.41780081986) | 5 | 1 | 1 | 28858 | 32 | ||||
| 72164 | 125374 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1051 Francisco St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6006272.5886 | 2120715.97126 | 37.8034358723358 | -122.422507500937 | (37.8034358723358, -122.422507500937) | 5 | 9 | 1 | 28858 | 32 | |||
| 107854 | 125388 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1172 Greenwich St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6007288.73286 | 2119886.64225 | 37.8012160163785 | -122.418932229062 | (37.8012160163785, -122.418932229062) | 5 | 1 | 1 | 28858 | 32 | |||
| 126127 | 125394 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 601 Beach St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6007295.97012 | 2121904.70723 | 37.8067575183062 | -122.419050406278 | (37.8067575183062, -122.419050406278) | 5 | 1 | 1 | 28858 | 32 | |||
| 138627 | 125376 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1051 Francisco St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6006287.77784 | 2120719.15167 | 37.8034454617947 | -122.422455163995 | (37.8034454617947, -122.422455163995) | 5 | 9 | 1 | 28858 | 32 | |||
| 147056 | 125361 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 5 Kimball Pl | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6007994.32097 | 2116413.82948 | 37.7917202403447 | -122.416244474729 | (37.7917202403447, -122.416244474729) | 5 | 1 | 10 | 28858 | 21 | |||
| 179224 | 125375 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1051 Francisco St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6006280.0736 | 2120717.56355 | 37.803440666609 | -122.422481711961 | (37.803440666609, -122.422481711961) | 5 | 9 | 1 | 28858 | 32 | |||
| 192581 | 125389 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1182 Greenwich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6007220.46315 | 2119868.37371 | 37.8011620111718 | -122.419167176043 | (37.8011620111718, -122.419167176043) | 5 | 1 | 1 | 28858 | 32 | ||||
| 9661 | 221676 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 302 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009690.29309 | 2099616.87031 | 37.7456948850248 | -122.409190595463 | (37.7456948850248, -122.409190595463) | 2 | 7 | 7 | 28859 | 2 | |||
| 16337 | 96163 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 195 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767795 | 6009794.5 | 2099949.7 | 37.7466145997749 | -122.408853739556 | (37.7466145997749, -122.408853739556) | 2 | 7 | 7 | 28859 | 2 | |
| 17214 | 69804 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 510 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6010631.84232 | 2105884.17134 | 37.7629562079975 | -122.406376362283 | (37.7629562079975, -122.406376362283) | 8 | 4 | 8 | 28859 | 19 | |||
| 43267 | 32318 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 3337 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/1996 12:00:00 AM | 3 | Permit Number 36887 | 6009065.50537 | 2099248.94213 | 37.7446496128893 | -122.411325040136 | (37.7446496128893, -122.411325040136) | 2 | 7 | 7 | 28859 | 2 | ||
| 59201 | 246635 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 3320 Harrison St | 6 | Front Yard : Yard | Tree | Private 2 | 9 | 6009033.15547 | 2099256.02578 | 37.7446672486036 | -122.41143740051 | (37.7446672486036, -122.41143740051) | 2 | 7 | 7 | 28859 | 2 | ||||
| 59624 | 220361 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 3378 18th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6007031.22663 | 2105582.9717 | 37.7619271056612 | -122.418808316877 | (37.7619271056612, -122.418808316877) | 8 | 4 | 7 | 28859 | 19 | |||
| 60467 | 220357 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 456 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008883.40187 | 2096190.5621 | 37.7362417548602 | -122.411738659938 | (37.7362417548602, -122.411738659938) | 10 | 7 | 7 | 28859 | 2 | |||
| 66290 | 221674 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1101 San Jose Ave | 63 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 6005018.97642 | 2096583.24508 | 37.7371024294214 | -122.425127515618 | (37.7371024294214, -122.425127515618) | 2 | 7 | 5 | 28859 | 2 | |||
| 68087 | 187819 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 530 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010638.06608 | 2105759.62754 | 37.7626145870019 | -122.406346060533 | (37.7626145870019, -122.406346060533) | 8 | 4 | 8 | 28859 | 19 | |||
| 72335 | 221671 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1211 San Bruno Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 4ft | 6011148.99057 | 2102603.41855 | 37.7539769072094 | -122.404356782652 | (37.7539769072094, -122.404356782652) | 10 | 4 | 8 | 28859 | 19 | |||
| 80148 | 220360 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 3378 18th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6007016.98848 | 2105579.87603 | 37.7619178039782 | -122.418857341599 | (37.7619178039782, -122.418857341599) | 8 | 4 | 7 | 28859 | 19 | |||
| 96533 | 221670 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 985 San Bruno Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6011091.323 | 2103767.31713 | 37.7571694924002 | -122.404638140957 | (37.7571694924002, -122.404638140957) | 10 | 4 | 8 | 28859 | 19 | |||
| 100761 | 221697 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 361 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006551.72063 | 2104011.45995 | 37.7575850897923 | -122.420355196653 | (37.7575850897923, -122.420355196653) | 2 | 4 | 7 | 28859 | 19 | |||
| 105870 | 221675 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 90 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005373.66792 | 2103191.42336 | 37.7552670062898 | -122.424371059896 | (37.7552670062898, -122.424371059896) | 2 | 4 | 5 | 28859 | 19 | |||
| 106112 | 221668 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 112 27th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 8ft | 6005711.74645 | 2100245.88519 | 37.747198322139 | -122.422992538592 | (37.747198322139, -122.422992538592) | 2 | 7 | 5 | 28859 | 22 | |||
| 120449 | 221695 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 44 Mirabel Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6007574.04417 | 2099916.56564 | 37.7463989948165 | -122.416529516648 | (37.7463989948165, -122.416529516648) | 2 | 7 | 7 | 28859 | 2 | |||
| 125327 | 221698 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2817 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009286.37688 | 2103324.82178 | 37.7558534568826 | -122.410849115294 | (37.7558534568826, -122.410849115294) | 2 | 4 | 7 | 28859 | 19 | |||
| 130607 | 220358 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1463 Shotwell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6008038.66764 | 2099636.78767 | 37.7456569057514 | -122.414903099011 | (37.7456569057514, -122.414903099011) | 2 | 7 | 7 | 28859 | 2 | |||
| 130804 | 221694 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 117 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6008278.04659 | 2099254.41861 | 37.744620453262 | -122.414048314086 | (37.744620453262, -122.414048314086) | 2 | 7 | 7 | 28859 | 2 | |||
| 133079 | 221691 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 67 Elsie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007442.11084 | 2099025.68484 | 37.7439454149504 | -122.416922619302 | (37.7439454149504, -122.416922619302) | 2 | 7 | 7 | 28859 | 2 | |||
| 143979 | 23683 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 326 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6006861.81806 | 2098078.15995 | 37.7413110650581 | -122.41886195603 | (37.7413110650581, -122.41886195603) | 2 | 7 | 7 | 28859 | 2 | |||
| 147714 | 220359 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1020 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009158.25384 | 2103078.96288 | 37.7551711988011 | -122.411274840882 | (37.7551711988011, -122.411274840882) | 2 | 4 | 7 | 28859 | 19 | |||
| 153408 | 63250 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 341 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/1987 12:00:00 AM | Permit Number 23802 | 6006556.22504592 | 2104122.60651516 | 37.7578905263243 | -122.420347507255 | (37.7578905263243, -122.420347507255) | 2 | 4 | 7 | 28859 | 19 | ||
| 158273 | 221692 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 63 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007455.59765 | 2099047.06577 | 37.7440048808367 | -122.416877499393 | (37.7440048808367, -122.416877499393) | 2 | 7 | 7 | 28859 | 2 | |||
| 162070 | 221678 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 123 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009783.0499 | 2099895.62844 | 37.7464654897831 | -122.408889518653 | (37.7464654897831, -122.408889518653) | 2 | 7 | 7 | 28859 | 2 | |||
| 168611 | 221693 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 57 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007477.41526 | 2099085.84176 | 37.7441125782394 | -122.416804805422 | (37.7441125782394, -122.416804805422) | 2 | 7 | 7 | 28859 | 2 | |||
| 171052 | 67167 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 92 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2008 12:00:00 AM | 3x3 | Permit Number 51915 | 6009125.10748473 | 2096937.35188264 | 37.7383058340982 | -122.410955710423 | (37.7383058340982, -122.410955710423) | 10 | 7 | 7 | 28859 | 2 | ||
| 180390 | 221696 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 46 Mirabel Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6007595.89057 | 2099927.51687 | 37.7464302930267 | -122.416454749686 | (37.7464302930267, -122.416454749686) | 2 | 7 | 7 | 28859 | 2 | |||
| 180704 | 221699 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 115 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006201.60829 | 2102393.63574 | 37.7531231834924 | -122.421451136554 | (37.7531231834924, -122.421451136554) | 2 | 4 | 5 | 28859 | 19 | |||
| 184160 | 221669 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 120 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 8ft | 6005709.14561 | 2100246.00775 | 37.7471985118996 | -122.423001540815 | (37.7471985118996, -122.423001540815) | 2 | 7 | 5 | 28859 | 22 | |||
| 188505 | 221677 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 306 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009672.05994 | 2099616.1831 | 37.7456919765986 | -122.409253594785 | (37.7456919765986, -122.409253594785) | 2 | 7 | 7 | 28859 | 2 | |||
| 191234 | 221672 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1209 San Bruno Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 4ft | 6011147.34779 | 2102647.41029 | 37.7540976070279 | -122.404365560027 | (37.7540976070279, -122.404365560027) | 10 | 4 | 8 | 28859 | 19 | |||
| 3925 | 96638 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 586 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767750 | 6001774.80022 | 2090099.6098 | 37.7191160424439 | -122.435880307331 | (37.7191160424439, -122.435880307331) | 9 | 7 | 6 | 28861 | 5 | |
| 9039 | 203339 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 201 Montana St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 5995007.64331 | 2089297.67598 | 37.7165273808053 | -122.459213572161 | (37.7165273808053, -122.459213572161) | 9 | 8 | 6 | 28861 | 24 | |||
| 28439 | 175098 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 160 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001025.23158 | 2087672.68531 | 37.7124096414687 | -122.438297499729 | (37.7124096414687, -122.438297499729) | 9 | 7 | 6 | 28861 | 5 | |||
| 30620 | 221701 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 130 Cuvier St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6004002.66039 | 2095058.43233 | 37.7328581734556 | -122.428532723922 | (37.7328581734556, -122.428532723922) | 9 | 7 | 5 | 28861 | 25 | |||
| 34701 | 203340 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 458 Orizaba Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 6ft | 5994050.25067 | 2089476.74481 | 37.7169639728763 | -122.462535752332 | (37.7169639728763, -122.462535752332) | 9 | 8 | 6 | 28861 | 24 | |||
| 48873 | 203338 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 247 Judson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5998510.07859 | 2093470.23079 | 37.7281849858352 | -122.447407627559 | (37.7281849858352, -122.447407627559) | 9 | 7 | 4 | 28861 | 40 | |||
| 56168 | 203387 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 262 Judson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5998346.86197 | 2093572.94917 | 37.7284576980424 | -122.447979263656 | (37.7284576980424, -122.447979263656) | 9 | 7 | 4 | 28861 | 40 | ||||
| 60162 | 175097 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 285 Foote Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5998274.15535 | 2088683.70515 | 37.7150288125979 | -122.447878758106 | (37.7150288125979, -122.447878758106) | 9 | 7 | 6 | 28861 | 25 | |||
| 65147 | 175121 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 224 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6001889.95807 | 2086593.68259 | 37.7094960826385 | -122.435231616459 | (37.7094960826385, -122.435231616459) | 9 | 7 | 6 | 28861 | 5 | |||
| 79358 | 175115 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 239 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002524.33543 | 2094177.44963 | 37.7303554249536 | -122.433580726478 | (37.7303554249536, -122.433580726478) | 9 | 7 | 5 | 28861 | 25 | |||
| 87722 | 35142 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 918 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 10 | Permit Number 38672 | 6001814.33321 | 2088634.2488 | 37.7150947329125 | -122.435638878045 | (37.7150947329125, -122.435638878045) | 9 | 7 | 6 | 28861 | 5 | |
| 89971 | 94042 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 641 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53452 | 6001625.67321 | 2089781.77052 | 37.7182348543375 | -122.436373045876 | (37.7182348543375, -122.436373045876) | 9 | 7 | 6 | 28861 | 5 | |
| 95295 | 31014 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1200 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 1 | Permit Number 43760 | 6001111.96152 | 2087453.85636 | 37.7118137183117 | -122.437982070624 | (37.7118137183117, -122.437982070624) | 9 | 7 | 6 | 28861 | 5 | |
| 106126 | 175123 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 316 Naylor St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6002739.89335 | 2086572.14483 | 37.7094851738594 | -122.432292561864 | (37.7094851738594, -122.432292561864) | 9 | 7 | 6 | 28861 | 5 |
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) );