trees

Custom SQL query returning 91 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
14802 11429 1 53 810X Mendell St 2 Sidewalk: Curb side : Cutout Tree 1     18 3X3   6016007.44377 2096780.42114 37.7382584597776 -122.387148815626 (37.7382584597776, -122.387148815626) 10 3 8 58 1
14874 6756 1 53 1215 Fairfax Ave 10 Sidewalk: Curb side : Cutout Tree 1     18 3x3 Permit Number 769095 6017521.0990665 2096743.3718322 37.7382404347673 -122.381912713319 (37.7382404347673, -122.381912713319) 10 3 8 58 1
18675 101715 4 53 560 Wisconsin St 1 Sidewalk: Curb side : Cutout Tree 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
19076 99594 4 53 1855X Evans Ave 9 Sidewalk: Curb side : Cutout Tree 2     10 3x3   6014349.8 2099426.2 37.7454312840379 -122.393065244865 (37.7454312840379, -122.393065244865) 10 3 8 58 1
20107 41196 7 53 500 16th St 8 Sidewalk: Curb side : Cutout Tree 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
23663 85059 1 53 2435 03rd St 4 Sidewalk: Curb side : Cutout Tree 1     6 4x9   6015831.18626 2104262.21936 37.7587921580004 -122.388280257816 (37.7587921580004, -122.388280257816) 10 3 8 28856 29
27391 6825 7 53 1450X Fairfax Ave 6 Sidewalk: Curb side : Cutout Tree 16     12 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
28345 6727 1 53 1200X Fairfax Ave 24 Sidewalk: Curb side : Cutout Tree 1     16 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
29445 26153 7 53 1500 Oakdale Ave 24 Sidewalk: Curb side : Cutout Tree 5     12 3X3   6015586.3934773 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626) 10 3 8 58 1
30509 109858 1 53 2455 03RD ST 4 Sidewalk: Curb side : Cutout Tree 1     15 5x8   6015836.2 2104173 37.7585474584562 -122.388256691115 (37.7585474584562, -122.388256691115) 10 3 8 28856 29
34152 21980 1 53 2575 03rd St 2 Sidewalk: Curb side : Cutout Tree 1     16 3x3   6015881.32806 2103602.42313 37.7569832760363 -122.388060799634 (37.7569832760363, -122.388060799634) 10 3 8 28856 29
35952 120884 4 53 2140x 18th St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6011295 2105636 37.7623118602886 -122.404065249735 (37.7623118602886, -122.404065249735) 8 3 8 28856 29
37080 6828 7 53 1450X Fairfax Ave 10 Sidewalk: Curb side : Cutout Tree 16     12 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
39117 14994 1 53 1459X Fairfax Ave 2 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6016235.7427248 2097702.9858463 37.7408042749191 -122.38642376985 (37.7408042749191, -122.38642376985) 10 3 8 58 1
41806 6719 1 53 1200X Fairfax Ave 16 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
43224 117205 7 53 1401 18th St 2 Sidewalk: Curb side : Cutout Tree 2           6013468.70293325 2105662.80878203 37.762506682391 -122.396549051509 (37.762506682391, -122.396549051509) 10 3 8 28856 29
46216 6816 7 53 1400X Fairfax Ave 8 Sidewalk: Curb side : Cutout Tree 16     12 3X3   6016560.8212721 2097522.8211505 37.7403275687029 -122.385287208511 (37.7403275687029, -122.385287208511) 10 3 8 58 1
48959 112162 7 53 1324 18th St 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6013680.97327942 2105726.70860795 37.7626939483281 -122.39581935837 (37.7626939483281, -122.39581935837) 14 3 8 28856 29
49286 21956 1 53 2475 03rd St 1 Sidewalk: Curb side : Cutout Tree 1     12 4x9   6015841.22266 2104083.69236 37.7583025169931 -122.388233087559 (37.7583025169931, -122.388233087559) 10 3 8 28856 29
50734 21952 1 53 2455 03RD ST 1 Sidewalk: Curb side : Cutout Tree 1     14 4x9   6015836.2 2104173 37.7585474584562 -122.388256691115 (37.7585474584562, -122.388256691115) 10 3 8 28856 29
52126 22281 7 53 4755X 03rd St 5 Sidewalk: Curb side : Cutout Tree 19     18 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
52462 116125 4 53 2500X Keith St 1 Sidewalk: Curb side : Cutout Tree 5           6014198.52795 2092093.45262 37.7252886606488 -122.393075349238 (37.7252886606488, -122.393075349238) 10 3 8 58 1
53748 110363 4 53 1899x MARIPOSA ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6011823 2106021 37.7633984709679 -122.402266155018 (37.7633984709679, -122.402266155018) 8 3 8 28856 29
54273 41195 7 53 500 16th St 10 Sidewalk: Curb side : Cutout Tree 2 FUF 02/03/1996 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
54784 101716 4 53 560 Wisconsin St 2 Sidewalk: Curb side : Cutout Tree 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
63265 6801 7 53 1385 Fairfax Ave 2 Sidewalk: Curb side : Cutout Tree 2     18 3x3   6016634.4993322 2097405.4643513 37.7400094064471 -122.385024282227 (37.7400094064471, -122.385024282227) 10 3 8 58 1
63978 119667 4 53 699x Missouri St 8 Sidewalk: Property side : Yard Tree 2           6013712 2104098 37.7582235960409 -122.395597929962 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
66362 6799 1 53 1375 Fairfax Ave 8 Sidewalk: Curb side : Cutout Tree 1     12 3x9   6016685.6205969 2097367.3215875 37.7399075017412 -122.384844867735 (37.7399075017412, -122.384844867735) 10 3 8 58 1
72329 6726 1 53 1200X Fairfax Ave 23 Sidewalk: Curb side : Cutout Tree 1     16 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
74408 6773 1 53 1355 Fairfax Ave 2 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6016787.8631263 2097291.0360599 37.7397036915046 -122.384486040227 (37.7397036915046, -122.384486040227) 10 3 8 58 1
77443 111583 7 53 1501-1555 Mariposa St 7 Sidewalk: Curb side : Cutout Tree 2           6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
78348 6705 1 53 1200X Fairfax Ave 2 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
78771 41194 7 53 500 16th St 9 Sidewalk: Curb side : Cutout Tree 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
79179 41198 7 53 500 16th St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
82003 41199 7 53 500 16th St 3 Sidewalk: Curb side : Cutout Tree 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
85621 21994 1 53 2585 03rd St 13 Sidewalk: Curb side : Cutout Tree 1     12 4x6   6015909.89309 2103367.89889 37.7563409047326 -122.387945645479 (37.7563409047326, -122.387945645479) 10 3 8 28856 29
85979 120943 4 53 485 Carolina St 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6012395 2105853 37.7629690927527 -122.400275979648 (37.7629690927527, -122.400275979648) 14 3 8 28856 29
87085 101725 4 53 560 Wisconsin St 11 Sidewalk: Curb side : Cutout Tree 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
89965 116128 4 53 2500X Keith St 4 Sidewalk: Curb side : Cutout Tree 5           6014198.52795 2092093.45262 37.7252886606488 -122.393075349238 (37.7252886606488, -122.393075349238) 10 3 8 58 1
90466 21986 1 53 2585 03rd St 6 Sidewalk: Curb side : Cutout Tree 1     12 4x9   6015885.54141 2103557.92781 37.7568613347581 -122.388043123198 (37.7568613347581, -122.388043123198) 10 3 8 28856 29
94460 101975 7 53 1230 19th St 2 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 769454 6013882 2105282.2 37.7614846061652 -122.395092936828 (37.7614846061652, -122.395092936828) 10 3 8 28856 29
100042 40805 7 53 585 Connecticut St 2 Sidewalk: Curb side : Cutout Tree 2         Permit Number 41753 6013296.02646982 2104345.28151099 37.758879430057 -122.397053895785 (37.758879430057, -122.397053895785) 10 3 8 28856 29
100521 111578 7 53 1501-1555 Mariposa St 2 Sidewalk: Curb side : Cutout Tree 2           6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
101295 29407 7 53 2801X Ingalls St 1 Sidewalk: Curb side : Cutout Tree 2     9 3X3   6014804.18454 2090650.03815 37.7213589569903 -122.390880803843 (37.7213589569903, -122.390880803843) 10 3 8 58 1
101430 111584 7 53 1501-1555 Mariposa St 8 Sidewalk: Curb side : Cutout Tree 2           6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
102193 6752 1 53 1215 Fairfax Ave 6 Sidewalk: Curb side : Cutout Tree 1     16 3x3   6017539.76894 2096719.16796 37.738175006759 -122.381846478456 (37.738175006759, -122.381846478456) 10 3 8 58 1
104299 21960 1 53 2525 03RD ST 2 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6015860.3 2103824.9 37.7575929852339 -122.388149048897 (37.7575929852339, -122.388149048897) 10 3 8 28856 29
105748 21991 1 53 2585 03rd St 2 Sidewalk: Curb side : Cutout Tree 1     18 4x6   6015885.54141 2103557.92781 37.7568613347581 -122.388043123198 (37.7568613347581, -122.388043123198) 10 3 8 28856 29
105989 101717 4 53 560 Wisconsin St 3 Sidewalk: Curb side : Cutout Tree 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
109428 116772 4 53 376 MISSOURI ST 1 Sidewalk: Curb side : Cutout Tree 2       7x9   6013450 2105342 37.7616247710574 -122.396591249035 (37.7616247710574, -122.396591249035) 10 3 8 28856 29
110376 25995 1 53 1781 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree 1     12 2X2   6014085.16035 2096167.03762 37.7364675981514 -122.39375225191 (37.7364675981514, -122.39375225191) 10 3 8 58 1
112959 21977 1 53 2573 03rd St 2 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6015880.48539 2103611.32219 37.7570076642803 -122.388064334928 (37.7570076642803, -122.388064334928) 10 3 8 28856 29
115268 6817 7 53 1400X Fairfax Ave 9 Sidewalk: Curb side : Cutout Tree 16     12 3X3   6016560.8212721 2097522.8211505 37.7403275687029 -122.385287208511 (37.7403275687029, -122.385287208511) 10 3 8 58 1
118179 21987 1 53 2585 03rd St 7 Sidewalk: Curb side : Cutout Tree 1     12 4x9   6015885.54141 2103557.92781 37.7568613347581 -122.388043123198 (37.7568613347581, -122.388043123198) 10 3 8 28856 29
121552 117206 7 53 1401 18th St 3 Sidewalk: Curb side : Cutout Tree 2           6013468.70293325 2105662.80878203 37.762506682391 -122.396549051509 (37.762506682391, -122.396549051509) 10 3 8 28856 29
122922 99595 4 53 1855X Evans Ave 10 Sidewalk: Curb side : Cutout Tree 2     10 3x3   6014349.8 2099426.2 37.7454312840379 -122.393065244865 (37.7454312840379, -122.393065244865) 10 3 8 58 1
122954 6709 1 53 1200X Fairfax Ave 6 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
123071 21969 1 53 2565 03rd St 1 Sidewalk: Curb side : Cutout Tree 1     12 4x6   6015991.1899 2103495.51019 37.7566958018452 -122.38767339342 (37.7566958018452, -122.38767339342) 10 3 8 28856 29
127555 110364 4 53 1899x MARIPOSA ST 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6011823 2106021 37.7633984709679 -122.402266155018 (37.7633984709679, -122.402266155018) 8 3 8 28856 29
128956 21983 1 53 2585 03rd St 3 Sidewalk: Curb side : Cutout Tree 1     12 4x9   6015885.54141 2103557.92781 37.7568613347581 -122.388043123198 (37.7568613347581, -122.388043123198) 10 3 8 28856 29
129171 27857 7 53 1450X Fairfax Ave 7 Sidewalk: Curb side : Cutout Tree 16     12 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
129331 21948 1 53 2435 03rd St 2 Sidewalk: Curb side : Cutout Tree 1     12 4x9   6015831.18626 2104262.21936 37.7587921580004 -122.388280257816 (37.7587921580004, -122.388280257816) 10 3 8 28856 29
135125 45390 7 53 1501-1555 Mariposa St 9 Sidewalk: Curb side : Cutout Tree 2   07/10/2001 12:00:00 AM     Permit Number 44202 6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
138070 101722 4 53 560 Wisconsin St 8 Sidewalk: Curb side : Cutout Tree 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
138111 111582 7 53 1501-1555 Mariposa St 6 Sidewalk: Curb side : Cutout Tree 2           6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
138887 101721 4 53 560 Wisconsin St 7 Sidewalk: Curb side : Cutout Tree 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
142509 6722 1 53 1200X Fairfax Ave 19 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
143054 57622 7 53 1401 18th St 1 Sidewalk: Curb side : Cutout Tree 2   11/15/1976 12:00:00 AM     Permit Number 16516 6013468.70293325 2105662.80878203 37.762506682391 -122.396549051509 (37.762506682391, -122.396549051509) 10 3 8 28856 29
143637 101724 4 53 560 Wisconsin St 10 Sidewalk: Curb side : Cutout Tree 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
146992 21975 1 53 2565 03rd St 7 Sidewalk: Curb side : Cutout Tree 1     23 4x6   6015991.1899 2103495.51019 37.7566958018452 -122.38767339342 (37.7566958018452, -122.38767339342) 10 3 8 28856 29
149060 6808 1 53 1395 Fairfax Ave 4 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6016583.3780675 2097443.6071151 37.7401113108781 -122.385203697211 (37.7401113108781, -122.385203697211) 10 3 8 58 1
150567 25558 1 53 50X Industrial St 3 Sidewalk: Curb side : Cutout Tree 1   01/23/2001 12:00:00 AM 8 4X4   6012204.29417 2097469.52586 37.7399392564551 -122.400346698766 (37.7399392564551, -122.400346698766) 10 3 8 58 1
151394 21984 1 53 2585 03rd St 4 Sidewalk: Curb side : Cutout Tree 1     12 4x9   6015885.54141 2103557.92781 37.7568613347581 -122.388043123198 (37.7568613347581, -122.388043123198) 10 3 8 28856 29
156118 41200 7 53 500 16th St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
158152 6829 7 53 1450X Fairfax Ave 11 Sidewalk: Curb side : Cutout Tree 16     12 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
158929 101720 4 53 560 Wisconsin St 6 Sidewalk: Curb side : Cutout Tree 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
161591 21959 1 53 2525 03RD ST 3 Sidewalk: Curb side : Cutout Tree 1     12 4x6   6015860.3 2103824.9 37.7575929852339 -122.388149048897 (37.7575929852339, -122.388149048897) 10 3 8 28856 29
163580 116126 4 53 2500X Keith St 2 Sidewalk: Curb side : Cutout Tree 5           6014198.52795 2092093.45262 37.7252886606488 -122.393075349238 (37.7252886606488, -122.393075349238) 10 3 8 58 1
165827 41193 7 53 500 16th St 7 Sidewalk: Curb side : Cutout Tree 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
169319 101719 4 53 560 Wisconsin St 5 Sidewalk: Curb side : Cutout Tree 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
169622 6721 1 53 1200X Fairfax Ave 18 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
174144 116127 4 53 2500X Keith St 3 Sidewalk: Curb side : Cutout Tree 5           6014198.52795 2092093.45262 37.7252886606488 -122.393075349238 (37.7252886606488, -122.393075349238) 10 3 8 58 1
176242 41192 7 53 500 16th St 6 Sidewalk: Curb side : Cutout Tree 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
176915 101718 4 53 560 Wisconsin St 4 Sidewalk: Curb side : Cutout Tree 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
179093 21930 1 53 2347 03rd St 2 Sidewalk: Curb side : Cutout Tree 1     12 3x5   6015939.39473 2104425.48438 37.7592464441674 -122.38791741203 (37.7592464441674, -122.38791741203) 10 3 8 28856 29
179159 101726 4 53 560 Wisconsin St 12 Sidewalk: Curb side : Cutout Tree 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
182806 112161 7 53 1324 18th St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6013680.97327942 2105726.70860795 37.7626939483281 -122.39581935837 (37.7626939483281, -122.39581935837) 14 3 8 28856 29
188021 6788 1 53 1390 Fairfax Ave 2 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6016787.1910829 2097353.9213772 37.7398763247169 -122.384492742853 (37.7398763247169, -122.384492742853) 10 3 8 58 1
188136 120939 4 53 485 Carolina St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6012395 2105853 37.7629690927527 -122.400275979648 (37.7629690927527, -122.400275979648) 14 3 8 28856 29
188909 6818 7 53 1400X Fairfax Ave 10 Sidewalk: Curb side : Cutout Tree 16     12 3X3   6016560.8212721 2097522.8211505 37.7403275687029 -122.385287208511 (37.7403275687029, -122.385287208511) 10 3 8 58 1
190734 6815 7 53 1400X Fairfax Ave 7 Sidewalk: Curb side : Cutout Tree 16     12 3X3   6016560.8212721 2097522.8211505 37.7403275687029 -122.385287208511 (37.7403275687029, -122.385287208511) 10 3 8 58 1