Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlantDate, DBH, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2371 | 2371 | 253059 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 421 Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.8080000002 | 37.728495991679296 | -122.368425863032 | (37.7284959916793, -122.368425863032) | ||
2373 | 2373 | 253062 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 451 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770412 | 6021215.947000001 | 2093217.369 | 37.728762049698204 | -122.36889409743 | (37.7287620496982, -122.36889409743) | ||
2385 | 2385 | 253058 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 421 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.8080000002 | 37.728495991679296 | -122.368425863032 | (37.7284959916793, -122.368425863032) | ||
2395 | 2395 | 253061 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 421 Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.8080000002 | 37.728495991679296 | -122.368425863032 | (37.7284959916793, -122.368425863032) | ||
2421 | 2421 | 253064 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 451 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770412 | 6021215.947000001 | 2093217.369 | 37.728762049698204 | -122.36889409743 | (37.7287620496982, -122.36889409743) | ||
2431 | 2431 | 253063 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 451 Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770412 | 6021215.947000001 | 2093217.369 | 37.728762049698204 | -122.36889409743 | (37.7287620496982, -122.36889409743) | ||
2462 | 2462 | 253060 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 421 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.8080000002 | 37.728495991679296 | -122.368425863032 | (37.7284959916793, -122.368425863032) | ||
4462 | 4462 | 160324 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 510X Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2017 02:10:00 PM | 3 | Width 0ft | 6001907.38785 | 2089113.4382599997 | 37.7164157659386 | -122.435351498769 | (37.7164157659386, -122.435351498769) | |
4490 | 4490 | 160323 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 510X Italy Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2017 01:57:00 PM | 3 | Width 0ft | 6001921.46763 | 2089105.50941 | 37.7163947946735 | -122.43530226538999 | (37.7163947946735, -122.43530226539) | |
4505 | 4505 | 160320 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 550X Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2017 02:08:00 PM | 3 | Width 0ft | 6001986.11056 | 2089065.71241 | 37.716289191780795 | -122.435075983386 | (37.7162891917808, -122.435075983386) | |
4631 | 4631 | 160530 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 420X France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 04:06:00 PM | 3 | Width 0ft | 6002060.6240300005 | 2089797.75117 | 37.7183034384358 | -122.434870749998 | (37.7183034384358, -122.434870749998) | |
4640 | 4640 | 160554 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 500 France Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:23:00 PM | 3 | Width 0ft | 6002263.49591 | 2089671.42563 | 37.717968092930995 | -122.43416048254299 | (37.717968092931, -122.434160482543) | |
4645 | 4645 | 160553 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 500 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:20:00 PM | 3 | Width 0ft | 6002250.4874599995 | 2089679.2270400003 | 37.7179887755522 | -122.434206004421 | (37.7179887755522, -122.434206004421) | |
4655 | 4655 | 160555 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 500 France Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:28:00 PM | 3 | Width 0ft | 6002272.40257 | 2089666.1121 | 37.7179540086612 | -122.43412931651599 | (37.7179540086612, -122.434129316516) | |
4664 | 4664 | 160319 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 550X Italy Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 11:39:00 AM | 3 | Width 0ft | 6002000.464380001 | 2089057.1552900001 | 37.7162665108705 | -122.435025758047 | (37.7162665108705, -122.435025758047) | |
4674 | 4674 | 148023 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 553X Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 11:52:00 AM | 3 | Width 3ft | 6001969.852469999 | 2089122.8198900002 | 37.716445073051894 | -122.435136261339 | (37.7164450730519, -122.435136261339) | |
4687 | 4687 | 160322 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 510X Italy Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 11:36:00 AM | 3 | Width 0ft | 6001932.580630001 | 2089099.8242400002 | 37.716379815556294 | -122.435263447059 | (37.7163798155563, -122.435263447059) | |
24618 | 24618 | 199641 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 251 Townsend St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014508.15812 | 2111374.30998 | 37.7782469922495 | -122.393353635873 | (37.7782469922495, -122.393353635873) | |||
25959 | 25959 | 199626 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 468 Mississippi St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6014046.309230001 | 2104968.95995 | 37.76063365303771 | -122.39450272031901 | (37.7606336530377, -122.394502720319) | |||
31009 | 31009 | 201796 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6021152.60745 | 2092710.04539 | 37.727365560462395 | -122.369078036218 | (37.7273655604624, -122.369078036218) | |||
35923 | 35923 | 199635 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 251 Townsend St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6014283.99479 | 2111159.66981 | 37.777645182120295 | -122.39411407471901 | (37.7776451821203, -122.394114074719) | |||
38953 | 38953 | 199639 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 251 Townsend St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014470.703369999 | 2111338.492 | 37.778146563160796 | -122.39348069927 | (37.7781465631608, -122.39348069927) | |||
41364 | 41364 | 48393 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 1325 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2002 12:00:00 AM | 4 | Permit Number 45775 | 5994526.8844099995 | 2112095.3213400003 | 37.7790963088496 | -122.462528007047 | (37.7790963088496, -122.462528007047) | ||
41925 | 41925 | 199633 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 251 Townsend St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6014252.555240001 | 2111130.1519 | 37.7775623851211 | -122.3942207685 | (37.7775623851211, -122.3942207685) | |||
46556 | 46556 | 199631 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 251 Townsend St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6014129.99187 | 2111017.59935 | 37.7772465279418 | -122.394636875801 | (37.7772465279418, -122.394636875801) | |||
50575 | 50575 | 181312 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 430 Wayland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010327.71055 | 2092289.1468200001 | 37.7256102097169 | -122.406470238016 | (37.7256102097169, -122.406470238016) | |||
51042 | 51042 | 181314 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 430 Wayland St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010227.9721099995 | 2092261.3423400002 | 37.72552828418279 | -122.406813068576 | (37.7255282841828, -122.406813068576) | |||
51350 | 51350 | 124468 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 349 Willard St North | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 6ft | 5996256.01193 | 2110505.30551 | 37.7748299686549 | -122.456431281339 | (37.7748299686549, -122.456431281339) | |||
51493 | 51493 | 201801 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 6 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6020978.953509999 | 2092836.83628 | 37.7277041785835 | -122.369687123669 | (37.7277041785835, -122.369687123669) | |||
51993 | 51993 | 201805 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 10 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6020879.60636 | 2092912.55986 | 37.727906650163 | -122.37003580431801 | (37.727906650163, -122.370035804318) | |||
52097 | 52097 | 201804 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 9 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6020904.74927 | 2092892.98725 | 37.7278542871344 | -122.369947531359 | (37.7278542871344, -122.369947531359) | |||
53206 | 53206 | 199637 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 251 Townsend St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014435.54732 | 2111305.4194099996 | 37.7780537998839 | -122.39360000243201 | (37.7780537998839, -122.393600002432) | |||
54542 | 54542 | 124470 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 349 Willard St North | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 6ft | 5996263.14672 | 2110459.34102 | 37.774704171801204 | -122.45640327637699 | (37.7747041718012, -122.456403276377) | |||
55370 | 55370 | 201806 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 11 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6020862.09511 | 2092930.7088400002 | 37.727955522906605 | -122.37009759584998 | (37.7279555229066, -122.37009759585) | |||
60632 | 60632 | 199628 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 468 Mississippi St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6014050.14145 | 2104918.93295 | 37.7604965028256 | -122.39448596326099 | (37.7604965028256, -122.394485963261) | |||
70745 | 70745 | 201798 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6021088.33309 | 2092752.01283 | 37.7274772697451 | -122.36930313385099 | (37.7274772697451, -122.369303133851) | |||
74528 | 74528 | 199630 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 251 Townsend St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6014102.184219999 | 2110987.44931 | 37.7771621967072 | -122.394730960159 | (37.7771621967072, -122.394730960159) | |||
75527 | 75527 | 199638 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 251 Townsend St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014451.54729 | 2111320.17279 | 37.7780951983723 | -122.393545685179 | (37.7780951983723, -122.393545685179) | |||
117293 | 117293 | 108429 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 3008 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770760 | 6008202.71085 | 2103306.38942 | 37.7557420230473 | -122.414595491952 | (37.7557420230473, -122.414595491952) |
122455 | 122455 | 55863 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 261 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1973 12:00:00 AM | 12 | 3x3 | Permit Number 11916 | 6005472.95954935 | 2102197.84365155 | 37.752544473461704 | -122.423957028973 | (37.7525444734617, -122.423957028973) | |
130168 | 130168 | 199629 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 498 Mississippi St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014051.430240001 | 2104855.90282 | 37.760323507448895 | -122.39447709236 | (37.7603235074489, -122.39447709236) | |||
133056 | 133056 | 201799 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6021051.90692 | 2092781.9816400001 | 37.727557560315795 | -122.36943113075 | (37.7275575603158, -122.36943113075) | |||
133877 | 133877 | 137603 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 1908 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003944.0414 | 2115071.5133 | 37.7878060009026 | -122.430162615236 | (37.7878060009026, -122.430162615236) | |||
134801 | 134801 | 244020 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 261 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005465.54578 | 2102195.1354 | 37.7525366186718 | -122.42398247451099 | (37.7525366186718, -122.423982474511) | |||
136830 | 136830 | 199632 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 251 Townsend St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6014144.2654 | 2111030.1540900003 | 37.77728179396429 | -122.394588378076 | (37.7772817939643, -122.394588378076) | |||
137906 | 137906 | 50162 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 100@ GROVE Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2003 12:00:00 AM | 6 | Permit Number 46875 | 5997802.2799 | 2110209.3118 | 37.7741058948892 | -122.45106109519101 | (37.7741058948892, -122.451061095191) | ||
150494 | 150494 | 216177 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 1228 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 4ft | 5992086.21496 | 2107042.53503 | 37.7650818635682 | -122.470603081182 | (37.7650818635682, -122.470603081182) | |||
160049 | 160049 | 199634 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 251 Townsend St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6014272.81594 | 2111147.6107900003 | 37.777611449438794 | -122.39415190199499 | (37.7776114494388, -122.394151901995) | |||
161146 | 161146 | 199636 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 251 Townsend St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6014300.61194 | 2111177.2028 | 37.777694247332605 | -122.394057817637 | (37.7776942473326, -122.394057817637) | |||
162727 | 162727 | 199644 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 251 Townsend St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014634.856430001 | 2111497.38858 | 37.7785919766832 | -122.39292394969699 | (37.7785919766832, -122.392923949697) | |||
163371 | 163371 | 201802 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 7 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6020947.47999 | 2092859.07822 | 37.7277635239432 | -122.369797465976 | (37.7277635239432, -122.369797465976) | |||
164353 | 164353 | 201797 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6021117.279709999 | 2092731.0926599998 | 37.7274214146518 | -122.369201619254 | (37.7274214146518, -122.369201619254) | |||
168726 | 168726 | 124469 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 349 Willard St North | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 5996258.69708 | 2110482.63653 | 37.774767879724294 | -122.456420353351 | (37.7747678797243, -122.456420353351) | |||
171150 | 171150 | 199627 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 468 Mississippi St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6014047.47282 | 2104941.97523 | 37.76055962355721 | -122.394496806394 | (37.7605596235572, -122.394496806394) | |||
172045 | 172045 | 199643 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 251 Townsend St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014542.45615 | 2111406.5622 | 37.778337455055706 | -122.393237242906 | (37.7783374550557, -122.393237242906) | |||
172936 | 172936 | 199645 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 251 Townsend St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6014649.6787 | 2111509.37371 | 37.778625708451294 | -122.392873512101 | (37.7786257084513, -122.392873512101) | |||
173709 | 173709 | 181311 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 430 Wayland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010368.97076 | 2092305.1155700001 | 37.725656364734505 | -122.40632872879499 | (37.7256563647345, -122.406328728795) | |||
174522 | 174522 | 199642 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 251 Townsend St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6014522.76224 | 2111389.3707 | 37.7782891569603 | -122.39330416865299 | (37.7782891569603, -122.393304168653) | |||
179141 | 179141 | 199640 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 251 Townsend St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014488.14989 | 2111355.44955 | 37.778194094118206 | -122.39342153199301 | (37.7781940941182, -122.393421531993) | |||
180740 | 180740 | 244019 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 57 Webster St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6004283.82971 | 2108814.32965 | 37.770644560714004 | -122.428540825916 | (37.770644560714, -122.428540825916) | |||
181683 | 181683 | 201803 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 8 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6020924.86388 | 2092877.32885 | 37.7278123958223 | -122.36987691208401 | (37.7278123958223, -122.369876912084) | |||
182476 | 182476 | 201800 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6021019.258830001 | 2092809.3324400003 | 37.7276308694498 | -122.36954588606001 | (37.7276308694498, -122.36954588606) | |||
186916 | 186916 | 181313 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 430 Wayland St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010292.07983 | 2092280.20746 | 37.7255836707225 | -122.40659278142401 | (37.7255836707225, -122.406592781424) | |||
188522 | 188522 | 113282 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 1972 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6003575.525 | 2118663.6131 | 37.79764810977 | -122.431694175277 | (37.79764810977, -122.431694175277) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");