trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
274 232433 1 9 100 Church St 2 : Tree 2     7 Width 3ft   6004078.25972 2108290.75217 37.7691953086514 -122.429214555715 (37.7691953086514, -122.429214555715) 7 9 5 28862 3
291 210733 1 9 239 Ramsell St 1 : Tree 2     7 Width 3ft   5992956.15258 2088805.34296 37.7150573966491 -122.466268722147 (37.7150573966491, -122.466268722147) 9 8 6 64 24
1727 249457 1 9 201 Olive St 2 : Tree 2     11 Width 4ft   6006319.82833 2113698.46294 37.7841702168319 -122.421845255461 (37.7841702168319, -122.421845255461) 7 9 11 28858 41
6418 194172 1 9 664 Wisconsin St 1 : Tree 2     6 Width 3ft   6012676.7573 2104370.99604 37.7589155441312 -122.399197435936 (37.7589155441312, -122.399197435936) 10 3 8 28856 29
9805 246529 1 9 95 Laguna St 2 : Tree 2     10 Width 4ft   6005210.23202 2109136.89842 37.77158263905 -122.425359343752 (37.77158263905, -122.425359343752) 7 9 5 28852 10
10208 250096 1 9 1701 Pine St 1 : Tree 2     7 Width 3ft   6005700.60971 2115508.13842 37.789104197049 -122.42411627476 (37.789104197049, -122.42411627476) 13 9 1 28858 41
18494 250097 1 9 1701 Pine St 3 : Tree 2     4 Width 3ft   6005753.06256 2115514.84991 37.7891255865184 -122.423935271799 (37.7891255865184, -122.423935271799) 13 9 1 28858 41
23967 210736 1 9 279 Ramsell St 1 : Tree 2     5 Width 3ft   5992958.08764 2089050.23377 37.7157299195648 -122.466279820655 (37.7157299195648, -122.466279820655) 9 8 6 64 24
25388 250487 1 9 222 El Camino Del Mar 1 : Tree 2     6 Width 3ft   5987893.38095 2115356.60419 37.7876666226671 -122.485715124257 (37.7876666226671, -122.485715124257) 11 6 1 55 33
29652 247670 1 9 170 Divisadero St 1 : Tree 2     4 Width 4ft   6001927.47375 2108582.27333 37.7698737616969 -122.436674865568 (37.7698737616969, -122.436674865568) 15 5 5 29492 9
38141 210728 1 9 113 Majestic Ave 1 : Tree 2     7 Width 3ft   5997053.85221 2089279.44742 37.716594756218 -122.4521395823 (37.716594756218, -122.4521395823) 9 8 6 28861 24
39257 249461 1 9 201 Olive St 6 : Tree 2     9 Width 4ft   6006433.55883 2113714.71473 37.7842212533479 -122.42145294241 (37.7842212533479, -122.42145294241) 7 9 11 28858 41
41527 194178 1 9 198 Missouri St 2 : Tree 2     4 Width 4ft   6013413.48709 2106240.03726 37.7640885515801 -122.396780493551 (37.7640885515801, -122.396780493551) 14 3 8 28856 29
43038 194194 1 9 1888 Illinois St 1 : Tree 2     10 Width 4ft   6016264.99223 2100427.37243 37.7482865000228 -122.386512551535 (37.7482865000228, -122.386512551535) 10 3 8 58 1
44605 246528 1 9 95 Laguna St 1 : Tree 2     13 Width 7ft   6005204.62433 2109172.65839 37.7716805104709 -122.425381286315 (37.7716805104709, -122.425381286315) 7 9 5 28852 10
45992 247778 1 9 250 30th St 1 : Tree 2     13 Width 3ft   6004957.69836 2098452.79483 37.7422323278575 -122.42547239214 (37.7422323278575, -122.42547239214) 2 7 5 63 22
51418 210594 1 9 1598 10th Ave 8 : Tree 2     6 Width 2ft   5993107.5867 2104697.22808 37.758701273452 -122.466899924805 (37.758701273452, -122.466899924805) 1 8 4 56 12
54847 249458 1 9 201 Olive St 3 : Tree 2     8 Width 4ft   6006350.21001 2113701.7523 37.7841809619115 -122.421740379236 (37.7841809619115, -122.421740379236) 7 9 11 28858 41
56635 247623 1 9 261 Bradford St 1 : Tree 2     3 Width 4ft   6009541.50836 2097060.71504 37.7386679035942 -122.409524699022 (37.7386679035942, -122.409524699022) 10 7 7 28859 2
56719 247696 1 9 66 Central Ave 1 : Tree 2     3 Width 4ft   5999969.16959 2108614.08966 37.7698496373709 -122.443450859673 (37.7698496373709, -122.443450859673) 15 5 11 29492 9
60206 249451 1 9 251 Olive St 1 : Tree 2     5 Width 3ft   6006114.5159 2113666.03761 37.7840696042744 -122.422553259352 (37.7840696042744, -122.422553259352) 7 9 11 28858 41
65824 194119 1 9 75 Oak Grove St 4 : Tree 2     7 Width 3ft   6012059.36571 2111084.51172 37.7773149177954 -122.401804583142 (37.7773149177954, -122.401804583142) 14 2 9 28856 34
66577 232434 1 9 100 Church St 1 : Tree 2     6 Width 3ft   6004077.27006 2108309.37309 37.7692463811546 -122.429219306844 (37.7692463811546, -122.429219306844) 7 9 5 28862 3
67266 194174 1 9 638 Arkansas St 1 : Tree 2     1 Width 3ft   6012975.69145 2104038.69902 37.7580197843001 -122.398140262177 (37.7580197843001, -122.398140262177) 10 3 8 28856 29
70001 249448 1 9 238 Olive St 2 : Tree 2     3 Width 3ft   6006176.73504 2113699.88088 37.7841660394729 -122.422340408706 (37.7841660394729, -122.422340408706) 7 9 11 28858 41
70346 249453 1 9 251 Olive St 3 : Tree 2     7 Width 3ft   6006151.02275 2113672.37502 37.7840890647107 -122.422427409114 (37.7840890647107, -122.422427409114) 7 9 11 28858 41
72990 210727 1 9 20 Majestic Ave 1 : Tree 2     8 Width 3ft   5997384.6848 2089822.80773 37.7181056433352 -122.451035225606 (37.7181056433352, -122.451035225606) 9 8 6 28861 24
74889 249460 1 9 201 Olive St 5 : Tree 2     11 Width 4ft   6006400.35451 2113710.64508 37.7842082068819 -122.421567528645 (37.7842082068819, -122.421567528645) 7 9 11 28858 41
75801 232436 1 9 98 Laussat St 2 : Tree 2     7 Width 3ft   6004291.45992 2109275.43151 37.7719110660771 -122.428547305538 (37.7719110660771, -122.428547305538) 7 9 11 28852 10
76952 194195 1 9 9 Pomona St 1 : Tree 2     2 Width 6ft   6014203.67115 2094680.19203 37.7323916096872 -122.393238495663 (37.7323916096872, -122.393238495663) 10 3 8 58 1
84342 249452 1 9 251 Olive St 2 : Tree 2     7 Width 3ft   6006131.50296 2113669.15355 37.7840791181899 -122.422494711663 (37.7840791181899, -122.422494711663) 7 9 11 28858 41
84624 250766 1 9 242 32nd Ave 1 : Tree 2     1 Width 3ft   5985905.94434 2114279.52557 37.7845932723154 -122.492511820787 (37.7845932723154, -122.492511820787) 11 6 1 55 33
86323 210737 1 9 283 Ramsell St 1 : Tree 2     6 Width 3ft   5992959.06004 2089081.22924 37.7158150817716 -122.466278710897 (37.7158150817716, -122.466278710897) 9 8 6 64 24
90815 210735 1 9 274 Ramsell St 1 : Tree 2     8 Width 3ft   5992991.6057 2089025.54794 37.7156640721019 -122.466162174951 (37.7156640721019, -122.466162174951) 9 8 6 64 24
91693 246530 1 9 95 Laguna St 3 : Tree 2     13 Width 7ft   6005220.62037 2109069.23024 37.7713974254703 -122.425318593679 (37.7713974254703, -122.425318593679) 7 9 5 28852 10
94459 232432 1 9 100 Church St 3 : Tree 2     15 Width 4ft   6004078.65513 2108269.95494 37.7691382268875 -122.429211704867 (37.7691382268875, -122.429211704867) 7 9 5 28862 3
94721 249455 1 9 251 Olive St 5 : Tree 2     9 Width 3ft   6006189.18478 2113676.83316 37.7841034583637 -122.422295698907 (37.7841034583637, -122.422295698907) 7 9 11 28858 41
113765 249449 1 9 250 Olive St 1 : Tree 2     8 Width 3ft   6006158.32839 2113696.95162 37.7841569581316 -122.422403881033 (37.7841569581316, -122.422403881033) 7 9 11 28858 41
115367 233148 1 9 3980 22nd St 10 : Tree 2     6     6001886.52284 2102943.06219 37.7543875349734 -122.4364128508 (37.7543875349734, -122.4364128508) 2 4 5 28862 22
120082 249456 1 9 201 Olive St 1 : Tree 2     4 Width 4ft   6006295.7266 2113694.91688 37.784159120994 -122.421928386997 (37.784159120994, -122.421928386997) 7 9 11 28858 41
121787 210725 1 9 20 Edgar Ave 1 : Tree 2     3 Width 3ft   5997113.75654 2090895.52443 37.7210355581178 -122.452049055632 (37.7210355581178, -122.452049055632) 9 8 6 28861 24
130017 250126 1 9 1730 Pine St 2 : Tree 2     10 Width 3ft   6005603.2664 2115542.36715 37.7891926840386 -122.424455506243 (37.7891926840386, -122.424455506243) 13 9 1 28858 41
132521 194179 1 9 198 Missouri St 3 : Tree 2     5 Width 4ft   6013413.98851 2106222.803 37.7640412580141 -122.396777550962 (37.7640412580141, -122.396777550962) 14 3 8 28856 29
135208 249462 1 9 201 Olive St 7 : Tree 2     9 Width 4ft   6006460.85988 2113718.34687 37.784232765583 -122.421358748315 (37.784232765583, -122.421358748315) 7 9 11 28858 41
136508 249459 1 9 201 Olive St 4 : Tree 2     8 Width 4ft   6006372.75274 2113706.04085 37.784194008402 -122.421662693996 (37.784194008402, -122.421662693996) 7 9 11 28858 41
138848 233160 1 9 130 Saint Germain Ave 1 : Tree 2     7 Width 3ft   5997752.88642 2104152.69917 37.7574731484793 -122.450795169568 (37.7574731484793, -122.450795169568) 15 5 4 28862 38
142682 249454 1 9 251 Olive St 4 : Tree 2     6 Width 3ft   6006170.8585 2113675.59 37.7840990111962 -122.422359012976 (37.7840990111962, -122.422359012976) 7 9 11 28858 41
143103 210729 1 9 2950 San Jose Ave 3 : Tree 2     3 Width 3ft   5996042.96304 2087509.51727 37.711676981779 -122.455505847225 (37.711676981779, -122.455505847225) 9 8 6 28861 24
145156 210596 1 9 1598 10th Ave 13 : Tree 2     8 Width 2ft   5993107.01633 2104712.46351 37.7587430730523 -122.466903004965 (37.7587430730523, -122.466903004965) 1 8 4 56 12
148198 249450 1 9 250 Olive St 2 : Tree 2     7 Width 3ft   6006131.65251 2113691.8301 37.7841413908581 -122.422495806137 (37.7841413908581, -122.422495806137) 7 9 11 28858 41
148696 232431 1 9 340 Church St 1 : Tree 2     1 Width 2ft   6004146.95621 2106961.59739 37.7655496594068 -122.428882166285 (37.7655496594068, -122.428882166285) 8 4 5 28862 3
149249 194121 1 9 174 Langton St 1 : Tree 2     4 Width 3ft   6010449.01935 2110432.74871 37.7754353293039 -122.407329361273 (37.7754353293039, -122.407329361273) 8 2 9 28853 34
156449 210597 1 9 1598 10th Ave 16 : Tree 2     5 Width 2ft   5993106.74835 2104720.89396 37.7587662054039 -122.466904544628 (37.7587662054039, -122.466904544628) 1 8 4 56 12
162835 249447 1 9 238 Olive St 1 : Tree 2     3 Width 3ft   6006223.8532 2113706.94532 37.7841880944532 -122.422177898507 (37.7841880944532, -122.422177898507) 7 9 11 28858 41
165446 233147 1 9 3978 22nd St 3 : Tree 2     2     6001977.86453 2102958.17095 37.7544342097936 -122.436098049399 (37.7544342097936, -122.436098049399) 2 4 5 28862 22
165519 210731 1 9 555 Arch St 1 : Tree 2     3 Width 3ft   5992721.77233 2090849.66532 37.7206570847417 -122.46722738773 (37.7206570847417, -122.46722738773) 9 8 6 64 24
165522 210726 1 9 2 Majestic Ave 1 : Tree 2     8 Width 3ft   5997442.65634 2089908.86719 37.7183452613979 -122.450841045792 (37.7183452613979, -122.450841045792) 9 8 6 28861 24
168209 210738 1 9 291 Ramsell St 1 : Tree 2     12 Width 3ft   5992961.95972 2089127.53233 37.7159423862175 -122.46627205144 (37.7159423862175, -122.46627205144) 9 8 6 64 24
168662 194120 1 9 75 Oak Grove St 5 : Tree 2     5 Width 3ft   6012056.17784 2111087.81775 37.7773238174893 -122.401815843529 (37.7773238174893, -122.401815843529) 14 2 9 28856 34
174105 210595 1 9 1598 10th Ave 11 : Tree 2     6 Width 2ft   5993107.35573 2104707.43103 37.7587292747629 -122.466901465326 (37.7587292747629, -122.466901465326) 1 8 4 56 12
177977 210739 1 9 378 Victoria St 1 : Tree 2     2 Width 3ft   5993261.2949 2089711.81841 37.7175639618854 -122.465279833897 (37.7175639618854, -122.465279833897) 9 8 6 64 24
178 233603 1 9 199 Franconia St 9 : Yard Tree 2     6 Width 3ft   6010152.72418 2099634.52308 37.7457692517475 -122.407592814071 (37.7457692517475, -122.407592814071) 2 7 7 28859 2
17455 233602 1 9 199 Franconia St 8 : Yard Tree 2     6 Width 3ft   6010143.5997 2099646.47131 37.7458015482156 -122.407625207637 (37.7458015482156, -122.407625207637) 2 7 7 28859 2
18454 233232 1 9 199 Franconia St 5 : Yard Tree 2     10 Width 3ft   6010129.8045 2099669.06085 37.7458628019252 -122.407674502171 (37.7458628019252, -122.407674502171) 2 7 7 28859 2
57749 233228 1 9 199 Franconia St 1 : Yard Tree 2     6 Width 3ft   6010113.61596 2099694.13241 37.7459307367175 -122.407732247644 (37.7459307367175, -122.407732247644) 2 7 7 28859 2
105926 233233 1 9 199 Franconia St 6 : Yard Tree 2     9 Width 3ft   6010125.25157 2099665.50304 37.745852778088 -122.407689994823 (37.745852778088, -122.407689994823) 2 7 7 28859 2
105985 233604 1 9 199 Franconia St 10 : Yard Tree 2     3 Width 3ft   6010160.0797 2099615.71546 37.7457180218657 -122.407566053833 (37.7457180218657, -122.407566053833) 2 7 7 28859 2
113227 233234 1 9 199 Franconia St 7 : Yard Tree 2     4 Width 3ft   6010136.86006 2099655.53222 37.7458260502241 -122.407649151211 (37.7458260502241, -122.407649151211) 2 7 7 28859 2
121948 177876 1 9 4117 San Bruno Ave 1 : Yard Tree 2     37 Width 10ft   6011467.53014 2087476.31968 37.7124588649577 -122.402191732263 (37.7124588649577, -122.402191732263) 10 7 8 309 39
134390 233605 1 9 199 Franconia St 12 : Yard Tree 2     9 Width 3ft   6010122.88511 2099649.32748 37.7458082310637 -122.407697037414 (37.7458082310637, -122.407697037414) 2 7 7 28859 2
135325 233231 1 9 199 Franconia St 4 : Yard Tree 2     6 Width 3ft   6010116.17645 2099679.88413 37.7458917573937 -122.407722389299 (37.7458917573937, -122.407722389299) 2 7 7 28859 2
146203 233229 1 9 199 Franconia St 2 : Yard Tree 2     5 Width 3ft   6010110.29265 2099690.95534 37.745921827137 -122.407743515268 (37.745921827137, -122.407743515268) 2 7 7 28859 2
158865 194131 1 9 1310 Indiana St 4 : Yard Tree 2     37     6014985.85621 2102536.59701 37.754007092062 -122.391083210127 (37.754007092062, -122.391083210127) 10 3 8 28856 29
160292 233230 1 9 199 Franconia St 3 : Yard Tree 2     5 Width 3ft   6010120.38838 2099686.6934 37.7459106899441 -122.407708305 (37.7459106899441, -122.407708305) 2 7 7 28859 2
10271 262199 6 9 801 Sanchez St 1 Back Yard : Yard Tree 2       3x3   6003778 2103544 37.7561448640021 -122.429914501498 (37.7561448640021, -122.429914501498) 2 4 5 28862 22
30830 253551 1 9 1000 Cayuga Ave 19 Back Yard : Yard Tree 1   09/22/2017 04:40:00 PM 3 3x3   6000652.97917 2091201.14277 37.7220768117153 -122.439836937152 (37.7220768117153, -122.439836937152) 9 7 6 28861 25
55894 253546 1 9 1000 Cayuga Ave 14 Back Yard : Yard Tree 1   09/27/2017 11:50:00 AM 3 3x3   6000652.97917 2091201.14277 37.7220768117153 -122.439836937152 (37.7220768117153, -122.439836937152) 9 7 6 28861 25
56235 253550 1 9 1000 Cayuga Ave 18 Back Yard : Yard Tree 1   09/27/2017 11:43:00 AM 3 3x3   6000652.97917 2091201.14277 37.7220768117153 -122.439836937152 (37.7220768117153, -122.439836937152) 9 7 6 28861 25
58983 253548 1 9 1000 Cayuga Ave 16 Back Yard : Yard Tree 1   09/22/2017 04:31:00 PM 3 3x3   6000652.97917 2091201.14277 37.7220768117153 -122.439836937152 (37.7220768117153, -122.439836937152) 9 7 6 28861 25
61431 253549 1 9 1000 Cayuga Ave 17 Back Yard : Yard Tree 1   09/27/2017 11:46:00 AM 3 3x3   6000652.97917 2091201.14277 37.7220768117153 -122.439836937152 (37.7220768117153, -122.439836937152) 9 7 6 28861 25
71809 96274 6 9 55@ Alemany Trumbull St 2 Back Yard : Yard Tree 2     2     6004001.3006 2094332.00643 37.7308634942567 -122.428485665086 (37.7308634942567, -122.428485665086) 9 7 6 28861 5
87305 253547 1 9 1000 Cayuga Ave 15 Back Yard : Yard Tree 1   09/27/2017 11:40:00 AM 3 3x3   6000652.97917 2091201.14277 37.7220768117153 -122.439836937152 (37.7220768117153, -122.439836937152) 9 7 6 28861 25
150154 96278 6 9 55@ Alemany Trumbull St 6 Back Yard : Yard Tree 2     2     6003898.31997 2094328.29867 37.7308474854131 -122.428841421596 (37.7308474854131, -122.428841421596) 9 7 6 28861 5
196 116631 4 9 5732X GEARY BLVD 12 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
416 116621 4 9 5732X GEARY BLVD 2 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
6720 116625 4 9 5732X GEARY BLVD 6 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
34791 116627 4 9 5732X GEARY BLVD 8 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
36632 116630 4 9 5732X GEARY BLVD 11 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
54248 115888 6 9 811 TREAT AVE 1 Front Yard : Cutout Tree 2     20 3x3   6008597 2103712 37.7568778816719 -122.413260590978 (37.7568778816719, -122.413260590978) 2 4 7 28859 19
85516 116628 4 9 5732X GEARY BLVD 9 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
89112 106184 6 9 1327 ULLOA ST 1 Front Yard : Cutout Tree 2 FUF   2 4x4   5991893.8 2098371.4 37.7412620575898 -122.470636971077 (37.7412620575898, -122.470636971077) 1 8 4 59 40
102606 116620 4 9 5732X GEARY BLVD 1 Front Yard : Cutout Tree 3 DPW   12 3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
107761 116629 4 9 5732X GEARY BLVD 10 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
134678 116624 4 9 5732X GEARY BLVD 5 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
167673 116622 4 9 5732X GEARY BLVD 3 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
174243 116623 4 9 5732X GEARY BLVD 4 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
67 99921 5 9 1740 Jones St 1 Front Yard : Yard Tree 2   06/01/2015 12:00:00 AM 3   Permit Number 774389 6008331.64636 2118443.68708 37.7973126906849 -122.415221079511 (37.7973126906849, -122.415221079511) 5 1 10 308 21
357 232461 1 9 1300 San Jose Ave 12 Front Yard : Yard Tree 2     11     6003612.68018 2095726.39764 37.7346701778724 -122.429928614715 (37.7346701778724, -122.429928614715) 2 7 5 63 7
3001 80365 1 9 500 Campbell Ave 1 Front Yard : Yard Tree 2 FUF   1     6010298.58269 2088549.93008 37.7153414628213 -122.406307590233 (37.7153414628213, -122.406307590233) 9 7 8 309 39
5173 169519 2 9 1753 Noe St 1 Front Yard : Yard Tree 2     0 8x8 Permit Number 779099 6003417.91334 2098032.77345 37.7409919262491 -122.430766523865 (37.7409919262491, -122.430766523865) 2 7 5 63 7
5300 194149 1 9 101 Pennsylvania Ave 40 Front Yard : Yard Tree 2     1     6014236.41284 2106693.24116 37.765378718967 -122.393965939285 (37.765378718967, -122.393965939285) 14 3 8 28856 20