trees
412 rows where qSpecies_id = 216 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
59429 | 187845 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 6014068.65615 | 2107267.60612 | 37.7669464738232 | -122.394586398647 | (37.7669464738232, -122.394586398647) | 14 | 3 | 9 | 310 | 20 | |||
188117 | 187846 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6014052.69217 | 2107285.98471 | 37.7669960498487 | -122.394642903074 | (37.7669960498487, -122.394642903074) | 14 | 3 | 9 | 310 | 20 | |||
171406 | 187847 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6014037.17214 | 2107299.70636 | 37.7670328636008 | -122.394697545853 | (37.7670328636008, -122.394697545853) | 14 | 3 | 9 | 310 | 20 | |||
71786 | 187848 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6014022.62191 | 2107316.98369 | 37.7670794943594 | -122.394749083307 | (37.7670794943594, -122.394749083307) | 14 | 3 | 9 | 310 | 20 | |||
46526 | 187849 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6013975.69295 | 2107357.62002 | 37.7671884634053 | -122.394914250996 | (37.7671884634053, -122.394914250996) | 14 | 3 | 9 | 310 | 20 | |||
149629 | 187850 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013958.61615 | 2107374.23355 | 37.7672331309277 | -122.3949744813 | (37.7672331309277, -122.3949744813) | 14 | 3 | 9 | 310 | 20 | |||
119951 | 187851 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013943.13627 | 2107389.9206 | 37.7672753433109 | -122.395029123218 | (37.7672753433109, -122.395029123218) | 14 | 3 | 9 | 310 | 20 | |||
7126 | 187852 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013926.08485 | 2107407.78513 | 37.7673234471545 | -122.395089353509 | (37.7673234471545, -122.395089353509) | 14 | 3 | 9 | 310 | 20 | |||
32421 | 187853 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013912.72569 | 2107421.82042 | 37.7673612420515 | -122.395136544518 | (37.7673612420515, -122.395136544518) | 14 | 3 | 9 | 310 | 20 | |||
63598 | 187854 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6013896.55337 | 2107438.77334 | 37.7674068916492 | -122.395193670376 | (37.7674068916492, -122.395193670376) | 14 | 3 | 9 | 310 | 20 | |||
139958 | 187855 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013880.1945 | 2107455.37205 | 37.7674515582618 | -122.395251416746 | (37.7674515582618, -122.395251416746) | 14 | 3 | 9 | 310 | 20 | |||
147734 | 187856 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1670 Owen St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013871.42116 | 2107465.38185 | 37.7674785550305 | -122.395282464041 | (37.7674785550305, -122.395282464041) | 14 | 3 | 9 | 310 | 20 | |||
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 | |||
92843 | 87388 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 201 Topeka Ave | 2 | Back Yard : Yard | Tree | Private 2 | 04/24/2008 12:00:00 AM | Permit Number 50366 | 6012955.9 | 2095077.8 | 37.7334139596128 | -122.397580237664 | (37.7334139596128, -122.397580237664) | 10 | 3 | 8 | 58 | 1 | |||
113800 | 87387 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 201 Topeka Ave | Back Yard : Yard | Tree | Private 2 | 04/24/2008 12:00:00 AM | Permit Number 50366 | 6012955.9 | 2095077.8 | 37.7334139596128 | -122.397580237664 | (37.7334139596128, -122.397580237664) | 10 | 3 | 8 | 58 | 1 | ||||
133016 | 87389 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 201 Topeka Ave | 3 | Back Yard : Yard | Tree | Private 2 | 04/24/2008 12:00:00 AM | Permit Number 50366 | 6012955.9 | 2095077.8 | 37.7334139596128 | -122.397580237664 | (37.7334139596128, -122.397580237664) | 10 | 3 | 8 | 58 | 1 | |||
78356 | 175100 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 499 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012716.46972 | 2086677.83624 | 37.7103360215502 | -122.397819010859 | (37.7103360215502, -122.397819010859) | 10 | 3 | 8 | 309 | 1 | |||
143016 | 175101 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 499 Lathrop Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012687.11436 | 2086687.84114 | 37.7103618581922 | -122.397921171135 | (37.7103618581922, -122.397921171135) | 10 | 3 | 8 | 309 | 1 | |||
113467 | 175102 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 499 Lathrop Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012641.62535 | 2086702.75705 | 37.7104002808186 | -122.398079437443 | (37.7104002808186, -122.398079437443) | 10 | 3 | 8 | 309 | 1 | |||
27697 | 187836 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1350 Rankin St | 2 | Side Yard : Yard | Tree | Private 2 | 2 | Width 2ft | 6012791.1903 | 2096920.73953 | 37.7384651145639 | -122.398278948414 | (37.7384651145639, -122.398278948414) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | |
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 | |
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 | |
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 | |
171961 | 175099 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 246 Hester Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6012405.6069 | 2087718.72316 | 37.7131767739728 | -122.398966433363 | (37.7131767739728, -122.398966433363) | 10 | 3 | 8 | 309 | 1 | |||
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 | |
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 | ||||
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 | ||||
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 | |
133543 | 98816 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 290 Napoleon St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011832.99645 | 2099730.66022 | 37.7461271360771 | -122.401789397166 | (37.7461271360771, -122.401789397166) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
67840 | 97192 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 18 Bartol St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6011743 | 2118577 | 37.7978698622465 | -122.403426241675 | (37.7978698622465, -122.403426241675) | 3 | 1 | 10 | 308 | 23 | |||||
188416 | 249968 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 213 Filbert St | 3 | Back Yard : Yard | Tree | Private 2 | 11 | Width 0ft | 6011722.66122 | 2120088.35569 | 37.8020185425825 | -122.403603012281 | (37.8020185425825, -122.403603012281) | 3 | 1 | 10 | 308 | 23 | |||
62890 | 187837 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2 Apparel Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6011250.95199 | 2097877.37741 | 37.7410059214738 | -122.403671667433 | (37.7410059214738, -122.403671667433) | 10 | 3 | 8 | 58 | 1 | |||
68191 | 187838 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2 Apparel Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6011238.47382 | 2097885.30068 | 37.7410269800211 | -122.403715369982 | (37.7410269800211, -122.403715369982) | 10 | 3 | 8 | 58 | 1 | |||
26751 | 175120 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 104 Burrows St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6011145.11517 | 2093506.87446 | 37.7289995314962 | -122.40373016652 | (37.7289995314962, -122.40373016652) | 10 | 3 | 7 | 309 | 28 | |||
62079 | 84123 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 15 Bishop St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50684 | 6010955.75977 | 2089742.14973 | 37.7186517953192 | -122.404119940781 | (37.7186517953192, -122.404119940781) | 10 | 7 | 8 | 309 | 39 | |
149068 | 249958 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 283 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | Width 0ft | 6011531.90819 | 2120075.94359 | 37.8019738048974 | -122.404262237813 | (37.8019738048974, -122.404262237813) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
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 | |||
156820 | 249995 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 41 Darrell Pl | 1 | Back Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6011498.48414 | 2120303.07103 | 37.8025955736741 | -122.404393897677 | (37.8025955736741, -122.404393897677) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
95667 | 33071 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1360 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | 4 | Permit Number 37332 | 6011470.52327 | 2119999.58164 | 37.8017607033429 | -122.404469281534 | (37.8017607033429, -122.404469281534) | 3 | 1 | 10 | 308 | 23 | ||
11432 | 33068 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1360 Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | 6 | Permit Number 37332 | 6011466.15955 | 2120021.30065 | 37.8018200945828 | -122.40448591181 | (37.8018200945828, -122.40448591181) | 3 | 1 | 10 | 308 | 23 | ||
8255 | 249853 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 285 Greenwich St | 4 | Front Yard : Yard | Tree | Private 2 | 7 | Width 0ft | 6011465.28647 | 2120398.88484 | 37.8028567997706 | -122.40451552739 | (37.8028567997706, -122.40451552739) | 3 | 1 | 10 | 308 | 23 | |||
136040 | 125396 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1306x Montgomery St | 28 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 6011438.36253 | 2120049.61228 | 37.8018962779427 | -122.404584097094 | (37.8018962779427, -122.404584097094) | 3 | 1 | 10 | 308 | 23 | |||
87191 | 249849 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 289 Greenwich St | 1 | Side Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6011439.22895 | 2120384.4493 | 37.8028157070334 | -122.404604683485 | (37.8028157070334, -122.404604683485) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
10005 | 249841 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1470 Montgomery St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 6011410.89749 | 2120342.69349 | 37.8026994723548 | -122.404699784063 | (37.8026994723548, -122.404699784063) | 3 | 1 | 10 | 308 | 23 | |||
131886 | 249842 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1470 Montgomery St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 6011409.7751 | 2120350.84076 | 37.8027217800346 | -122.40470424202 | (37.8027217800346, -122.40470424202) | 3 | 1 | 10 | 308 | 23 | |||
139731 | 249843 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 1470 Montgomery St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 0ft | 6011406.1385 | 2120362.03253 | 37.8027523066439 | -122.404717614929 | (37.8027523066439, -122.404717614929) | 3 | 1 | 10 | 308 | 23 | |||
45331 | 107372 | Undocumented 4 | Acer palmatum :: Japanese Maple 216 | 305x GREENWICH ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 20 | 6011370 | 2120243 | 37.8024234525216 | -122.404834287898 | (37.8024234525216, -122.404834287898) | 3 | 1 | 10 | 308 | 23 | ||||
185264 | 250216 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 308 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 6011344.36464 | 2120071.55622 | 37.8019512768773 | -122.404910921503 | (37.8019512768773, -122.404910921503) | 3 | 1 | 10 | 308 | 23 | |||
67921 | 250217 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 308 Filbert St | 3 | Front Yard : Yard | Tree | Private 2 | 7 | Width 0ft | 6011333.4654 | 2120069.14279 | 37.8019440409451 | -122.40494846819 | (37.8019440409451, -122.40494846819) | 3 | 1 | 10 | 308 | 23 | |||
47030 | 249838 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 305 Greenwich St | 1 | Side Yard : Yard | Tree | Private 2 | 14 | Width 0ft | 6011296.05526 | 2120375.39097 | 37.8027828323166 | -122.405099502142 | (37.8027828323166, -122.405099502142) | 3 | 1 | 10 | 308 | 23 | |||
81302 | 249839 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 305 Greenwich St | 2 | Side Yard : Yard | Tree | Private 2 | 15 | Width 0ft | 6011296.15098 | 2120380.09271 | 37.8027957474947 | -122.405099502163 | (37.8027957474947, -122.405099502163) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
56190 | 175103 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 56 Tomaso Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009154.75517 | 2086318.89701 | 37.709151452539 | -122.410103762579 | (37.709151452539, -122.410103762579) | 9 | 7 | 8 | 309 | 39 | |||
58193 | 175096 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 56 Tomaso Ct | 1 | : | Tree | Private 2 | 1 | Width 2ft | 6009154.58159 | 2086320.62957 | 37.7091562000666 | -122.410104484734 | (37.7091562000666, -122.410104484734) | 9 | 7 | 8 | 309 | 39 | |||
56771 | 87398 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 668 Dartmouth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50369 | 6009215.73569 | 2091111.89123 | 37.7223154426943 | -122.410231178548 | (37.7223154426943, -122.410231178548) | 9 | 3 | 7 | 309 | 28 | |
165950 | 87397 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 668 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50369 | 6009213.07274 | 2091121.28635 | 37.722341090456 | -122.41024104678 | (37.722341090456, -122.41024104678) | 9 | 3 | 7 | 309 | 28 | |
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 | |||
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 | ||
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 | |||
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 | ||||
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 | |||
96521 | 125380 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 10 Fallon Pl | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6008921.33225 | 2118578.8099 | 37.7977168271187 | -122.41319016839 | (37.7977168271187, -122.41319016839) | 3 | 1 | 10 | 308 | 21 | ||||
117725 | 125387 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 941 Vallejo St | 7 | Front Yard : Yard | Tree | Private 2 | 2 | 6008922.06708 | 2118675.50985 | 37.7979823825383 | -122.413194467167 | (37.7979823825383, -122.413194467167) | 3 | 1 | 10 | 308 | 21 | ||||
97642 | 125381 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 10 Fallon Pl | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6008898.87665 | 2118577.20166 | 37.7977111506028 | -122.413267757408 | (37.7977111506028, -122.413267757408) | 3 | 1 | 10 | 308 | 21 | ||||
126683 | 125382 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 10 Fallon Pl | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6008858.79836 | 2118571.71552 | 37.7976938368446 | -122.413406051567 | (37.7976938368446, -122.413406051567) | 3 | 1 | 10 | 308 | 21 | ||||
167088 | 125383 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 10 Fallon Pl | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6008843.29101 | 2118569.75825 | 37.7976875919697 | -122.413459572924 | (37.7976875919697, -122.413459572924) | 3 | 1 | 10 | 308 | 21 |
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) );