trees
39 rows where Zip Codes = 63 and qSpecies_id = 50 sorted by Location
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
175338 | 226824 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 463 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6003840.68463 | 2095954.97206 | 37.7353107011233 | -122.429156618694 | (37.7353107011233, -122.429156618694) | 2 | 7 | 5 | 63 | 7 | |||
29492 | 94652 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 463 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779226 | 6003847 | 2095961 | 37.735327609986 | -122.429135213798 | (37.735327609986, -122.429135213798) | 2 | 7 | 5 | 63 | 7 |
4829 | 158177 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 340 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6003950.61422 | 2096725.29328 | 37.7374320507564 | -122.42883145083 | (37.7374320507564, -122.42883145083) | 2 | 7 | 5 | 63 | 7 | |||
54136 | 226376 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 268 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004329.65759 | 2096832.9872 | 37.7377492002742 | -122.427528590399 | (37.7377492002742, -122.427528590399) | 2 | 7 | 5 | 63 | 7 | |||
66767 | 88284 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 270 Whitney St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51280 | 6004294.4 | 2096874.5 | 37.7378611907196 | -122.427653449759 | (37.7378611907196, -122.427653449759) | 2 | 7 | 5 | 63 | 7 | |||
20342 | 226375 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 235 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004677.73219 | 2096935.71561 | 37.7380509507014 | -122.426332439909 | (37.7380509507014, -122.426332439909) | 2 | 7 | 5 | 63 | 7 | |||
11124 | 230876 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 241 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2020 01:31:00 PM | 3 | Width 4ft | 6004420.76549 | 2097018.25838 | 37.7382630656916 | -122.427226779685 | (37.7382630656916, -122.427226779685) | 2 | 7 | 5 | 63 | 7 | ||
130550 | 34378 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 192 Laidley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38129 | 6004119.49989193 | 2097245.26729923 | 37.7388693385577 | -122.428284582088 | (37.7388693385577, -122.428284582088) | 2 | 7 | 5 | 63 | 7 | ||
41208 | 226823 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 192 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004115.91768 | 2097275.83468 | 37.7389530669259 | -122.428299145692 | (37.7389530669259, -122.428299145692) | 2 | 7 | 5 | 63 | 7 | |||
178845 | 34366 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1891 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38122 | 6004628.22720814 | 2097641.9206333 | 37.7399872310586 | -122.426553875593 | (37.7399872310586, -122.426553875593) | 2 | 7 | 5 | 63 | 7 | ||
139345 | 226820 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1891 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004617.45608 | 2097657.55415 | 37.740029548214 | -122.426592230667 | (37.740029548214, -122.426592230667) | 2 | 7 | 5 | 63 | 7 | |||
25503 | 94663 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1883 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53800 | 6004614 | 2097695 | 37.7401321706185 | -122.426606846161 | (37.7401321706185, -122.426606846161) | 2 | 7 | 5 | 63 | 7 | |
28240 | 226821 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1883 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004617.16315 | 2097706.60415 | 37.740164211802 | -122.42659673537 | (37.740164211802, -122.42659673537) | 2 | 7 | 5 | 63 | 7 | |||
64290 | 226822 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 39 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004297.5525 | 2098038.31795 | 37.7410569481125 | -122.427725448366 | (37.7410569481125, -122.427725448366) | 2 | 7 | 5 | 63 | 7 | |||
38739 | 229867 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 474 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002892.54695 | 2098627.83365 | 37.7425960442853 | -122.432625542146 | (37.7425960442853, -122.432625542146) | 2 | 7 | 5 | 63 | 22 | |||
31441 | 50614 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 474 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2003 12:00:00 AM | Permit Number 47214 | 6002793.31412073 | 2098675.69251057 | 37.7427218255103 | -122.432972078444 | (37.7427218255103, -122.432972078444) | 2 | 7 | 5 | 63 | 22 | |||
189425 | 37050 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 278 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39655 | 6004138.71288838 | 2098700.07455731 | 37.7428649936747 | -122.428321811345 | (37.7428649936747, -122.428321811345) | 2 | 7 | 5 | 63 | 22 | ||
28908 | 229866 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 116 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005094.82025 | 2098749.88858 | 37.7430558262652 | -122.425019400031 | (37.7430558262652, -122.425019400031) | 2 | 7 | 5 | 63 | 22 | |||
153478 | 37047 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 116 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39653 | 6005177.12153831 | 2098757.26684492 | 37.7430807339727 | -122.424735348964 | (37.7430807339727, -122.424735348964) | 2 | 7 | 5 | 63 | 22 | ||
10934 | 226371 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 626 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002431.85737 | 2098894.22226 | 37.7433013483718 | -122.43423751036 | (37.7433013483718, -122.43423751036) | 2 | 7 | 5 | 63 | 22 | |||
74132 | 229869 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 314 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003810.99153 | 2099557.89821 | 37.7452018299076 | -122.42951614338 | (37.7452018299076, -122.42951614338) | 2 | 7 | 5 | 63 | 22 | |||
113449 | 37029 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 314 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39639 | 6003842.3126639 | 2099561.92709037 | 37.7452146656232 | -122.429408127516 | (37.7452146656232, -122.429408127516) | 2 | 7 | 5 | 63 | 22 | ||
24224 | 229868 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 248 28th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6004337.80093 | 2099585.86328 | 37.7453084292413 | -122.427696518086 | (37.7453084292413, -122.427696518086) | 2 | 7 | 5 | 63 | 22 | |||
133172 | 37028 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 238 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39638 | 6004336.0974524 | 2099589.08608997 | 37.7453171819754 | -122.427702638011 | (37.7453171819754, -122.427702638011) | 2 | 7 | 5 | 63 | 22 | ||
193864 | 256057 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 238 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39638 | 6004331 | 2099600 | 37.7453468607112 | -122.427721041632 | (37.7453468607112, -122.427721041632) | 2 | 7 | 5 | 63 | 22 | ||
78203 | 229880 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 482 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003343.61389 | 2100112.58509 | 37.7466983971062 | -122.431171839302 | (37.7466983971062, -122.431171839302) | 2 | 7 | 5 | 63 | 22 | |||
69633 | 94514 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 476 27th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53699 | 6003420 | 2100114 | 37.746706610489 | -122.430907804941 | (37.746706610489, -122.430907804941) | 2 | 7 | 5 | 63 | 22 | ||||
31293 | 229879 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 402 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003795.059 | 2100140.55813 | 37.7468007768344 | -122.429612782729 | (37.7468007768344, -122.429612782729) | 2 | 7 | 5 | 63 | 22 | |||
128537 | 229878 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 402 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003817.08439 | 2100142.49851 | 37.746807351775 | -122.429536759424 | (37.746807351775, -122.429536759424) | 2 | 7 | 5 | 63 | 22 | |||
116173 | 37022 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 402 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39634 | 6003883.04118176 | 2100148.50226599 | 37.7468275709653 | -122.429309115245 | (37.7468275709653, -122.429309115245) | 2 | 7 | 5 | 63 | 22 | ||
175959 | 37023 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 402 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39634 | 6003883.04118176 | 2100148.50226599 | 37.7468275709653 | -122.429309115245 | (37.7468275709653, -122.429309115245) | 2 | 7 | 5 | 63 | 22 | ||
33974 | 229877 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 376 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004079.13209 | 2100156.42335 | 37.7468604198839 | -122.428631616054 | (37.7468604198839, -122.428631616054) | 2 | 7 | 5 | 63 | 22 | |||
74013 | 229876 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 231 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004828.77791 | 2100152.44223 | 37.746891885367 | -122.42603912601 | (37.746891885367, -122.42603912601) | 2 | 7 | 5 | 63 | 22 | |||
82467 | 226366 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1220 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001939.37968 | 2100462.15738 | 37.7475785645179 | -122.436052541893 | (37.7475785645179, -122.436052541893) | 2 | 4 | 5 | 63 | 22 | |||
135145 | 226365 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1214 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001939.89483 | 2100487.05511 | 37.7476469570616 | -122.436052541887 | (37.7476469570616, -122.436052541887) | 2 | 4 | 5 | 63 | 22 | |||
117639 | 114960 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1214 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2015 12:00:00 AM | Permit Number 770791 | 6001920.2 | 2100491.9 | 37.7476591410723 | -122.436120992025 | (37.7476591410723, -122.436120992025) | 2 | 4 | 5 | 63 | 22 | |||
21984 | 105306 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4365 26th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2014 12:00:00 AM | 3x3 | Permit Number 771671 | 6001537.2 | 2100535.2 | 37.7477562656077 | -122.437448482105 | (37.7477562656077, -122.437448482105) | 2 | 4 | 5 | 63 | 22 | |||
133178 | 108708 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1220 Diamond St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774630 | 6001943.85423 | 2100537.23082 | 37.7477849526289 | -122.436042440417 | (37.7477849526289, -122.436042440417) | 2 | 4 | 5 | 63 | 22 | |
131153 | 226364 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4365 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001531.18753 | 2100555.73376 | 37.7478123046113 | -122.437470743076 | (37.7478123046113, -122.437470743076) | 2 | 4 | 5 | 63 | 22 |
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) );