trees
59 rows where Zip Codes = 28862 and qSpecies_id = 6
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
618 | 238270 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 4102 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6002298.332 | 2104734.40291 | 37.7593295173753 | -122.435116825204 | (37.7593295173753, -122.435116825204) | 2 | 4 | 5 | 28862 | 3 | |||
5680 | 227559 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 84 Seward St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6000741.27617 | 2104538.3206 | 37.7587025846742 | -122.44048780488 | (37.7587025846742, -122.44048780488) | 2 | 4 | 5 | 28862 | 38 | |||
8363 | 238269 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 4102 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6002324.68279 | 2104735.52248 | 37.7593340877084 | -122.435025771543 | (37.7593340877084, -122.435025771543) | 2 | 4 | 5 | 28862 | 3 | |||
9616 | 92857 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1101 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2009 12:00:00 AM | Permit Number 53074 | 6001966 | 2100891 | 37.7487575771252 | -122.435991171851 | (37.7487575771252, -122.435991171851) | 2 | 4 | 5 | 28862 | 22 | |||
15444 | 89331 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 4658 18th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51984 | 6000201 | 2105201 | 37.7604913603716 | -122.4424038966 | (37.7604913603716, -122.4424038966) | 15 | 4 | 5 | 28862 | 3 | |||
16149 | 244604 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4020 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6002870 | 2104782 | 37.7594926524767 | -122.433143121723 | (37.7594926524767, -122.433143121723) | 2 | 4 | 5 | 28862 | 3 | |||
16319 | 258436 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4050 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002636 | 2104802 | 37.7595342910111 | -122.433953838093 | (37.7595342910111, -122.433953838093) | 2 | 4 | 5 | 28862 | 3 | ||||
17128 | 39895 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 290 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50795 | 6001095.73329197 | 2104700.06064199 | 37.7591668603211 | -122.439273525739 | (37.7591668603211, -122.439273525739) | 2 | 4 | 5 | 28862 | 3 | ||
21439 | 227577 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 18 Dehon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 6003773.27056 | 2106456.0684 | 37.7641404406581 | -122.430138593823 | (37.7641404406581, -122.430138593823) | 8 | 4 | 5 | 28862 | 3 | |||
24824 | 227123 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 483 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002011.92527 | 2100876.50462 | 37.7487203851357 | -122.435831325762 | (37.7487203851357, -122.435831325762) | 2 | 4 | 5 | 28862 | 22 | |||
26995 | 227570 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 287 Hartford St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002738.3349 | 2104276.75984 | 37.7580979146911 | -122.433562376711 | (37.7580979146911, -122.433562376711) | 2 | 4 | 5 | 28862 | 3 | |||
31711 | 227556 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Seward St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000674.34081 | 2104608.13246 | 37.7588904593411 | -122.440724304978 | (37.7588904593411, -122.440724304978) | 2 | 4 | 5 | 28862 | 38 | |||
32952 | 37416 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1137 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51465 | 6001976.15825924 | 2100785.18555 | 37.7484676127991 | -122.435948474317 | (37.7484676127991, -122.435948474317) | 2 | 4 | 5 | 28862 | 22 | ||
37946 | 227574 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 11 Beaver St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002707.53405 | 2106779.67068 | 37.764968555288 | -122.433847795453 | (37.764968555288, -122.433847795453) | 15 | 5 | 5 | 28862 | 3 | |||
43943 | 227551 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 571 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003034.11181 | 2104925.46753 | 37.7598958878974 | -122.432585790315 | (37.7598958878974, -122.432585790315) | 2 | 4 | 5 | 28862 | 3 | |||
47337 | 83396 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 4058 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50820 | 6002600.50899636 | 2105341.51117361 | 37.7610136443426 | -122.43411515125 | (37.7610136443426, -122.43411515125) | 15 | 4 | 5 | 28862 | 3 | ||
51475 | 227564 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4547 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6000867.43951 | 2104613.62235 | 37.7589165280041 | -122.440056874944 | (37.7589165280041, -122.440056874944) | 2 | 4 | 5 | 28862 | 38 | |||
51502 | 94694 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 12 Dehon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53832 | 6003771 | 2106542 | 37.7643762595393 | -122.430152577782 | (37.7643762595393, -122.430152577782) | 8 | 4 | 5 | 28862 | 3 | |
55354 | 92858 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1101 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2009 12:00:00 AM | 3x3 | Permit Number 53074 | 6001966 | 2100891 | 37.7487575771252 | -122.435991171851 | (37.7487575771252, -122.435991171851) | 2 | 4 | 5 | 28862 | 22 | ||
59335 | 227553 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4445 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001135.34377 | 2105211.25899 | 37.760572740148 | -122.439173173223 | (37.760572740148, -122.439173173223) | 2 | 4 | 5 | 28862 | 3 | |||
60551 | 227567 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 308 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001758.47595 | 2103911.51009 | 37.7570393829676 | -122.436924995793 | (37.7570393829676, -122.436924995793) | 2 | 4 | 5 | 28862 | 3 | |||
71720 | 227560 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 84 Seward St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000737.03493 | 2104555.7602 | 37.7587502280493 | -122.440503723791 | (37.7587502280493, -122.440503723791) | 2 | 4 | 5 | 28862 | 38 | |||
75523 | 227127 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 105 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000615.36032 | 2102512.03507 | 37.7531317270504 | -122.440777928875 | (37.7531317270504, -122.440777928875) | 2 | 4 | 5 | 28862 | 22 | |||
79351 | 227582 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 288 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000368.64642 | 2106819.94984 | 37.7649461504603 | -122.441940289115 | (37.7649461504603, -122.441940289115) | 15 | 5 | 5 | 28862 | 3 | |||
80064 | 83344 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 4443-4445 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50816 | 6001265.82005399 | 2105215.83153824 | 37.7605927188575 | -122.43872224382 | (37.7605927188575, -122.43872224382) | 2 | 4 | 5 | 28862 | 3 | ||
86722 | 94695 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 12 Dehon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53832 | 6003771 | 2106542 | 37.7643762595393 | -122.430152577782 | (37.7643762595393, -122.430152577782) | 8 | 4 | 5 | 28862 | 3 | |
108856 | 88244 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 4330 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51231 | 6000585 | 2105809 | 37.7621826583789 | -122.441119442302 | (37.7621826583789, -122.441119442302) | 15 | 5 | 5 | 28862 | 3 | |||
109069 | 227555 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4611 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000604.66017 | 2104640.67953 | 37.7589758571809 | -122.440967627376 | (37.7589758571809, -122.440967627376) | 2 | 4 | 5 | 28862 | 38 | |||
109623 | 227566 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 91 Clover Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6000468.02748 | 2104951.63177 | 37.7598218728073 | -122.441462479323 | (37.7598218728073, -122.441462479323) | 2 | 4 | 5 | 28862 | 3 | |||
111067 | 227578 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 18 Dehon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 6003773.29998 | 2106438.61168 | 37.7640925103737 | -122.430137246636 | (37.7640925103737, -122.430137246636) | 8 | 4 | 5 | 28862 | 3 | |||
111372 | 105757 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 1278 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2014 12:00:00 AM | 10 | 3x3 | Permit Number 771070 | 5999104.9 | 2105310.4 | 37.7607292094813 | -122.446202658218 | (37.7607292094813, -122.446202658218) | 15 | 5 | 5 | 28862 | 3 | |
111414 | 227548 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 290 Jersey St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6003268.76291 | 2101573.30364 | 37.7507049460775 | -122.431534930712 | (37.7507049460775, -122.431534930712) | 2 | 4 | 5 | 28862 | 22 | |||
114201 | 227581 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4330 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000546.38941 | 2105812.04672 | 37.7621888245883 | -122.441253199888 | (37.7621888245883, -122.441253199888) | 15 | 5 | 5 | 28862 | 3 | |||
123672 | 227562 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4567 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000777.25512 | 2104640.3736 | 37.7589848458951 | -122.440370692454 | (37.7589848458951, -122.440370692454) | 2 | 4 | 5 | 28862 | 38 | |||
126325 | 92859 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1101 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2009 12:00:00 AM | 3x3 | Permit Number 53074 | 6001966 | 2100891 | 37.7487575771252 | -122.435991171851 | (37.7487575771252, -122.435991171851) | 2 | 4 | 5 | 28862 | 22 | ||
127065 | 227546 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4281 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6001381.67551 | 2101715.76186 | 37.7509889636801 | -122.438070830104 | (37.7509889636801, -122.438070830104) | 2 | 4 | 5 | 28862 | 22 | |||
135643 | 227554 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 359 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001158.33464 | 2104306.33401 | 37.7580893450524 | -122.439028803251 | (37.7580893450524, -122.439028803251) | 2 | 4 | 5 | 28862 | 3 | |||
142405 | 227565 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 290 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001097.22568 | 2104712.62438 | 37.7592014422066 | -122.439269264885 | (37.7592014422066, -122.439269264885) | 2 | 4 | 5 | 28862 | 3 | |||
144465 | 227561 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 84 Seward St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6000738.66154 | 2104570.78605 | 37.7587915779822 | -122.44049917592 | (37.7587915779822, -122.44049917592) | 2 | 4 | 5 | 28862 | 38 | |||
145480 | 102180 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 308 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769770 | 6001747.5 | 2103909.1 | 37.7570321415971 | -122.436962782195 | (37.7570321415971, -122.436962782195) | 2 | 4 | 5 | 28862 | 3 |
148398 | 227552 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4058 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002586.75589 | 2105341.84005 | 37.7610137667981 | -122.43416274072 | (37.7610137667981, -122.43416274072) | 15 | 4 | 5 | 28862 | 3 | |||
152823 | 227125 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 483 Clipper St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002044.61682 | 2100877.86818 | 37.7487259861351 | -122.435718376327 | (37.7487259861351, -122.435718376327) | 2 | 4 | 5 | 28862 | 22 | |||
153442 | 227122 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1137 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6001978.98288 | 2100703.16052 | 37.7482425519531 | -122.435932838524 | (37.7482425519531, -122.435932838524) | 2 | 4 | 5 | 28862 | 22 | |||
154133 | 227547 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 780 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6001390.11593 | 2102052.79607 | 37.7519148588942 | -122.438065782205 | (37.7519148588942, -122.438065782205) | 2 | 4 | 5 | 28862 | 22 | |||
159117 | 51978 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 571 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50788 | 6003031.54377055 | 2104930.91129788 | 37.7599106895436 | -122.432595060758 | (37.7599106895436, -122.432595060758) | 2 | 4 | 5 | 28862 | 3 | ||
160845 | 227580 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 23 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003811.04552 | 2108200.21185 | 37.7689315761679 | -122.430132375016 | (37.7689315761679, -122.430132375016) | 7 | 9 | 5 | 28862 | 3 | |||
162715 | 227569 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 287 Hartford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002739.75043 | 2104260.6213 | 37.7580536824469 | -122.433556327872 | (37.7580536824469, -122.433556327872) | 2 | 4 | 5 | 28862 | 3 | |||
164479 | 88270 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 288 States St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51256 | 6000346 | 2106829 | 37.7649697094425 | -122.442019266807 | (37.7649697094425, -122.442019266807) | 15 | 5 | 5 | 28862 | 3 | ||
164870 | 87861 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 96 Caselli Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50803 | 6000485.4 | 2104954.1 | 37.7598296396585 | -122.441402573572 | (37.7598296396585, -122.441402573572) | 2 | 4 | 5 | 28862 | 3 | ||
168688 | 227572 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 841 Church St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004362.06253 | 2104151.54801 | 37.7578461063327 | -122.427937906015 | (37.7578461063327, -122.427937906015) | 2 | 4 | 5 | 28862 | 3 | |||
168808 | 227549 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3663 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003979.9607 | 2103616.2837 | 37.7563547731686 | -122.429221207098 | (37.7563547731686, -122.429221207098) | 2 | 4 | 5 | 28862 | 22 | |||
172005 | 227579 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 77 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004499.29505 | 2107353.29779 | 37.7666451110058 | -122.427691415339 | (37.7666451110058, -122.427691415339) | 8 | 4 | 5 | 28862 | 3 | |||
172352 | 227550 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3957 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003307.61262 | 2104748.70742 | 37.7594260532954 | -122.431627264983 | (37.7594260532954, -122.431627264983) | 2 | 4 | 5 | 28862 | 3 | |||
172497 | 227124 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 483 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002026.8924 | 2100876.99711 | 37.7487225875918 | -122.435779604843 | (37.7487225875918, -122.435779604843) | 2 | 4 | 5 | 28862 | 22 | |||
177211 | 102935 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 801X Church St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6004394.3 | 2104124.7 | 37.7577742117678 | -122.427824502367 | (37.7577742117678, -122.427824502367) | 2 | 4 | 5 | 28862 | 3 | |||
180998 | 227573 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4658 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000184.94355 | 2105205.65777 | 37.7605032342671 | -122.442459762729 | (37.7605032342671, -122.442459762729) | 15 | 4 | 5 | 28862 | 3 | |||
181931 | 102200 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 579 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2013 12:00:00 AM | 4 | 3x3 | Permit Number 769774 | 6002583.2 | 2103808 | 37.7568020093443 | -122.434065390673 | (37.7568020093443, -122.434065390673) | 2 | 4 | 5 | 28862 | 3 |
187092 | 227571 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 579 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002573.48599 | 2103832.36646 | 37.7568683624992 | -122.434100727063 | (37.7568683624992, -122.434100727063) | 2 | 4 | 5 | 28862 | 3 | |||
187150 | 227568 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 287 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002743.27179 | 2104198.28781 | 37.7578827294299 | -122.433539694925 | (37.7578827294299, -122.433539694925) | 2 | 4 | 5 | 28862 | 3 |
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) );