trees
1,194 rows where 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30844 | 36599 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1423 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39452 | 6009585.61659215 | 2100916.70354088 | 37.7492580755485 | -122.409644280871 | (37.7492580755485, -122.409644280871) | 2 | 4 | 7 | 28859 | 19 | ||
74807 | 10220 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1366 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 6005800.08489 | 2101007.66776 | 37.7492949871928 | -122.422741198761 | (37.7492949871928, -122.422741198761) | 2 | 4 | 5 | 28859 | 19 | |||
95097 | 37750 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1411 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/2003 12:00:00 AM | Permit Number 40097 | 6009582.81268414 | 2100967.48036218 | 37.7493973403348 | -122.409657560346 | (37.7493973403348, -122.409657560346) | 2 | 4 | 7 | 28859 | 19 | ||
127792 | 33046 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 444 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37323 | 6005481.54643554 | 2101117.54369538 | 37.7495787038819 | -122.423850524117 | (37.7495787038819, -122.423850524117) | 2 | 4 | 5 | 28859 | 19 | ||
176006 | 33047 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 444 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37323 | 6005481.54643554 | 2101117.54369538 | 37.7495787038819 | -122.423850524117 | (37.7495787038819, -122.423850524117) | 2 | 4 | 5 | 28859 | 19 | ||
127759 | 229813 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3000 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009511.58464 | 2101042.5615 | 37.7495995048357 | -122.409909169093 | (37.7495995048357, -122.409909169093) | 2 | 4 | 7 | 28859 | 19 | |||
5083 | 229812 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3000 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009519.76237 | 2101043.00477 | 37.7496011802691 | -122.409880921395 | (37.7496011802691, -122.409880921395) | 2 | 4 | 7 | 28859 | 19 | |||
106402 | 61391 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3006 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768380 | 6009515.29830856 | 2101045.50817637 | 37.7496078038852 | -122.409896535031 | (37.7496078038852, -122.409896535031) | 2 | 4 | 7 | 28859 | 19 |
120676 | 229814 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2851 26th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010203.85183 | 2101034.69033 | 37.7496166656959 | -122.407514719648 | (37.7496166656959, -122.407514719648) | 2 | 4 | 7 | 28859 | 19 | |||
127965 | 36578 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2833 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2002 12:00:00 AM | Permit Number 39440 | 6010288.37913672 | 2101036.1480817 | 37.7496253993391 | -122.407222522654 | (37.7496253993391, -122.407222522654) | 2 | 4 | 7 | 28859 | 19 | ||
51702 | 97477 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3000 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768380 | 6009497.8 | 2101066.6 | 37.7496647366653 | -122.409958533785 | (37.7496647366653, -122.409958533785) | 2 | 4 | 7 | 28859 | 19 |
107178 | 97476 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3000 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768380 | 6009497.8 | 2101066.6 | 37.7496647366653 | -122.409958533785 | (37.7496647366653, -122.409958533785) | 2 | 4 | 7 | 28859 | 19 |
127610 | 226368 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4252 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6002219.8956 | 2101222.17774 | 37.7496813332396 | -122.43513688726 | (37.7496813332396, -122.43513688726) | 2 | 4 | 5 | 28862 | 22 | |||
116513 | 220576 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4248 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781634 | 6002235.87131 | 2101222.78245 | 37.7496839007903 | -122.435081685973 | (37.7496839007903, -122.435081685973) | 2 | 4 | 5 | 28862 | 22 | |
88747 | 228551 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1398 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009530.29917 | 2101073.08548 | 37.7496843657442 | -122.409846607735 | (37.7496843657442, -122.409846607735) | 2 | 4 | 7 | 28859 | 19 | |||
113498 | 67792 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4252 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52966 | 6002229.57555078 | 2101227.41307609 | 37.7496962578989 | -122.435103788069 | (37.7496962578989, -122.435103788069) | 2 | 4 | 5 | 28862 | 22 | |
85315 | 33045 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 435 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/2000 12:00:00 AM | Permit Number 37322 | 6005530.37891091 | 2101176.15171839 | 37.7497423846708 | -122.423685826158 | (37.7497423846708, -122.423685826158) | 2 | 4 | 5 | 28859 | 19 | ||
82529 | 226774 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4069 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003404.88062 | 2101242.91418 | 37.7498054882307 | -122.431040646222 | (37.7498054882307, -122.431040646222) | 2 | 4 | 5 | 28862 | 22 | |||
31239 | 226775 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4065 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003443.87888 | 2101243.2515 | 37.7498086241662 | -122.430905812676 | (37.7498086241662, -122.430905812676) | 2 | 4 | 5 | 28862 | 22 | |||
140045 | 226369 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 935 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001947.50433 | 2101286.4879 | 37.7498424422864 | -122.436083426409 | (37.7498424422864, -122.436083426409) | 2 | 4 | 5 | 28862 | 22 | |||
156574 | 226370 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 929 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001946.0113 | 2101316.44103 | 37.7499246016413 | -122.436090732519 | (37.7499246016413, -122.436090732519) | 2 | 4 | 5 | 28862 | 22 | |||
117450 | 226321 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1153 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008080.72157 | 2101209.59973 | 37.7499778586098 | -122.414868977829 | (37.7499778586098, -122.414868977829) | 2 | 4 | 7 | 28859 | 19 | |||
117197 | 34779 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1153 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38418 | 6008088.1654875 | 2101216.34832832 | 37.7499968070134 | -122.414843713866 | (37.7499968070134, -122.414843713866) | 2 | 4 | 7 | 28859 | 19 | ||
141115 | 34778 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1153 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38418 | 6008088.1654875 | 2101216.34832832 | 37.7499968070134 | -122.414843713866 | (37.7499968070134, -122.414843713866) | 2 | 4 | 7 | 28859 | 19 | ||
146330 | 228550 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1376 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009526.3637 | 2101188.14814 | 37.7500000817346 | -122.40986833805 | (37.7500000817346, -122.40986833805) | 2 | 4 | 7 | 28859 | 19 | |||
83390 | 226322 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1153 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008078.2472 | 2101222.93823 | 37.7500143440966 | -122.414878478273 | (37.7500143440966, -122.414878478273) | 2 | 4 | 7 | 28859 | 19 | |||
85838 | 33044 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 417 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37321 | 6005524.82070863 | 2101276.46802426 | 37.7500175164074 | -122.423712178429 | (37.7500175164074, -122.423712178429) | 2 | 4 | 5 | 28859 | 19 | ||
46513 | 82600 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1380-1382 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52212 | 6010324.92053454 | 2101179.2577549 | 37.7500203919907 | -122.407106246848 | (37.7500203919907, -122.407106246848) | 2 | 4 | 7 | 28859 | 19 | |
55948 | 50586 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 941 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2003 12:00:00 AM | Permit Number 47201 | 6001947.38784558 | 2101357.03323011 | 37.7500361363805 | -122.436088876747 | (37.7500361363805, -122.436088876747) | 2 | 4 | 5 | 28862 | 22 | |||
15582 | 34308 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
19118 | 34336 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
25134 | 34329 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
34493 | 34309 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
45805 | 34314 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
52340 | 34319 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 30 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
56528 | 34320 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 31 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
58181 | 34312 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
60736 | 34327 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
72978 | 34338 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
81858 | 34307 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
89178 | 34318 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
99407 | 34313 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
100567 | 34321 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
107938 | 34311 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 32 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
110878 | 34326 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
111213 | 34335 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
139065 | 34317 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
142907 | 34337 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
148478 | 34331 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
150302 | 34324 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
156109 | 34315 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
157772 | 34316 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
160328 | 34333 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
162785 | 34322 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 27 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
163887 | 34330 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
165341 | 34325 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
167135 | 34334 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
179728 | 34310 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
184316 | 34332 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
189461 | 34328 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
191516 | 34323 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
85522 | 37415 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 935 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39893 | 6001946.57451683 | 2101373.82273034 | 37.75008219015 | -122.436092890574 | (37.75008219015, -122.436092890574) | 2 | 4 | 5 | 28862 | 22 | ||
52802 | 37414 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 929 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39892 | 6001945.76118783 | 2101390.6122358 | 37.7501282439333 | -122.436096904408 | (37.7501282439333, -122.436096904408) | 2 | 4 | 5 | 28862 | 22 | ||
167891 | 226319 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1363 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6009300.51192 | 2101248.84299 | 37.7501540762619 | -122.410653634171 | (37.7501540762619, -122.410653634171) | 2 | 4 | 7 | 28859 | 19 | |||
52380 | 228547 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6009559.03474 | 2101249.47013 | 37.7501702892497 | -122.409759687354 | (37.7501702892497, -122.409759687354) | 2 | 4 | 7 | 28859 | 19 | |||
181150 | 226323 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1139 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008076.0678 | 2101289.03077 | 37.7501956968847 | -122.414890691951 | (37.7501956968847, -122.414890691951) | 2 | 4 | 7 | 28859 | 19 | |||
61958 | 34774 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1139 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1999 12:00:00 AM | Permit Number 38415 | 6008083.82317224 | 2101294.64403942 | 37.750211545435 | -122.414864270544 | (37.750211545435, -122.414864270544) | 2 | 4 | 7 | 28859 | 19 | ||
126449 | 34733 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1417 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | Permit Number 38383 | 6006486.84635329 | 2101329.65317057 | 37.7502178094357 | -122.420389210833 | (37.7502178094357, -122.420389210833) | 2 | 4 | 7 | 28859 | 19 | |||
146261 | 34732 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1417 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | Permit Number 38383 | 6006486.84635329 | 2101329.65317057 | 37.7502178094357 | -122.420389210833 | (37.7502178094357, -122.420389210833) | 2 | 4 | 7 | 28859 | 19 | |||
153942 | 34730 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1417 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | Permit Number 38383 | 6006486.84635329 | 2101329.65317057 | 37.7502178094357 | -122.420389210833 | (37.7502178094357, -122.420389210833) | 2 | 4 | 7 | 28859 | 19 | |||
156928 | 34731 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1417 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | Permit Number 38383 | 6006486.84635329 | 2101329.65317057 | 37.7502178094357 | -122.420389210833 | (37.7502178094357, -122.420389210833) | 2 | 4 | 7 | 28859 | 19 | |||
124658 | 228541 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1380 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | Permit Number 782155 | 6010322.60009 | 2101256.71389 | 37.7502329396187 | -122.407119730208 | (37.7502329396187, -122.407119730208) | 2 | 4 | 7 | 28859 | 19 | ||
52183 | 228548 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6009560.01396 | 2101278.1954 | 37.7502492173426 | -122.409758328497 | (37.7502492173426, -122.409758328497) | 2 | 4 | 7 | 28859 | 19 | |||
17101 | 36665 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1361 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39471 | 6010110.56144118 | 2101283.13510395 | 37.750293617943 | -122.407854839546 | (37.750293617943, -122.407854839546) | 2 | 4 | 7 | 28859 | 19 | ||
94876 | 226416 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1118 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008031.51023 | 2101373.79083 | 37.7504259251155 | -122.415050773974 | (37.7504259251155, -122.415050773974) | 2 | 4 | 7 | 28859 | 19 | |||
56974 | 226417 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1116 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008029.19909 | 2101392.11657 | 37.7504761135956 | -122.415060063068 | (37.7504761135956, -122.415060063068) | 2 | 4 | 7 | 28859 | 19 | |||
168405 | 37760 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1349 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2001 12:00:00 AM | Permit Number 43826 | 6010106.85455823 | 2101350.26433307 | 37.7504777324538 | -122.407872391397 | (37.7504777324538, -122.407872391397) | 2 | 4 | 7 | 28859 | 19 | ||
145243 | 226418 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1116 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008030.04777 | 2101411.71526 | 37.7505299748764 | -122.415058515332 | (37.7505299748764, -122.415058515332) | 2 | 4 | 7 | 28859 | 19 | |||
77587 | 190707 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2221 26th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011869.78299 | 2101342.9203 | 37.7505561064965 | -122.401775500866 | (37.7505561064965, -122.401775500866) | 10 | 3 | 8 | 28856 | 1 | |||
61215 | 190706 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2221 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011852.8073 | 2101343.3115 | 37.7505562332917 | -122.401834231975 | (37.7505562332917, -122.401834231975) | 10 | 3 | 8 | 28856 | 1 | |||
121096 | 36598 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1334 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2002 12:00:00 AM | Permit Number 39451 | 6009507.07319393 | 2101395.95284749 | 37.7505695862007 | -122.40994971369 | (37.7505695862007, -122.40994971369) | 2 | 4 | 7 | 28859 | 19 | ||
35536 | 34771 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1112 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 11 | Permit Number 38413 | 6008023.83866277 | 2101437.17080746 | 37.7505995211504 | -122.415081788574 | (37.7505995211504, -122.415081788574) | 2 | 4 | 7 | 28859 | 19 | |
121695 | 34770 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1112 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 11 | Permit Number 38413 | 6008023.83866277 | 2101437.17080746 | 37.7505995211504 | -122.415081788574 | (37.7505995211504, -122.415081788574) | 2 | 4 | 7 | 28859 | 19 | |
124310 | 34772 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1112 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 11 | Permit Number 38413 | 6008023.83866277 | 2101437.17080746 | 37.7505995211504 | -122.415081788574 | (37.7505995211504, -122.415081788574) | 2 | 4 | 7 | 28859 | 19 | |
192061 | 228549 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009550.58062 | 2101412.53302 | 37.7506175499731 | -122.409800431165 | (37.7506175499731, -122.409800431165) | 2 | 4 | 7 | 28859 | 19 | |||
4647 | 36593 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39450 | 6009555.90279082 | 2101454.80149403 | 37.7507339080729 | -122.409785009854 | (37.7507339080729, -122.409785009854) | 2 | 4 | 7 | 28859 | 19 | ||
13806 | 36597 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2002 12:00:00 AM | Permit Number 39450 | 6009555.90279082 | 2101454.80149403 | 37.7507339080729 | -122.409785009854 | (37.7507339080729, -122.409785009854) | 2 | 4 | 7 | 28859 | 19 | ||
90048 | 36592 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39450 | 6009555.90279082 | 2101454.80149403 | 37.7507339080729 | -122.409785009854 | (37.7507339080729, -122.409785009854) | 2 | 4 | 7 | 28859 | 19 | ||
124078 | 36595 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39450 | 6009555.90279082 | 2101454.80149403 | 37.7507339080729 | -122.409785009854 | (37.7507339080729, -122.409785009854) | 2 | 4 | 7 | 28859 | 19 | ||
162205 | 36596 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39450 | 6009555.90279082 | 2101454.80149403 | 37.7507339080729 | -122.409785009854 | (37.7507339080729, -122.409785009854) | 2 | 4 | 7 | 28859 | 19 | ||
192647 | 36594 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39450 | 6009555.90279082 | 2101454.80149403 | 37.7507339080729 | -122.409785009854 | (37.7507339080729, -122.409785009854) | 2 | 4 | 7 | 28859 | 19 | ||
73046 | 226344 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3175 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008415.43541 | 2101520.84505 | 37.7508512702694 | -122.413733528893 | (37.7508512702694, -122.413733528893) | 2 | 4 | 7 | 28859 | 19 | |||
131079 | 226345 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3175 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008443.19224 | 2101522.80952 | 37.7508582229518 | -122.413637681828 | (37.7508582229518, -122.413637681828) | 2 | 4 | 7 | 28859 | 19 | |||
67944 | 34742 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2901 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38391 | 6008387.19520521 | 2101524.63770013 | 37.7508600981217 | -122.413831454694 | (37.7508600981217, -122.413831454694) | 2 | 4 | 7 | 28859 | 19 | ||
98393 | 34741 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2901 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38391 | 6008387.19520521 | 2101524.63770013 | 37.7508600981217 | -122.413831454694 | (37.7508600981217, -122.413831454694) | 2 | 4 | 7 | 28859 | 19 | ||
101742 | 34743 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2901 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38391 | 6008387.19520521 | 2101524.63770013 | 37.7508600981217 | -122.413831454694 | (37.7508600981217, -122.413831454694) | 2 | 4 | 7 | 28859 | 19 | ||
137953 | 34734 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3175 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38384 | 6008507.54779719 | 2101522.76910569 | 37.7508617255783 | -122.413415130751 | (37.7508617255783, -122.413415130751) | 2 | 4 | 7 | 28859 | 19 | ||
68852 | 226346 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3175 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008464.57897 | 2101524.14473 | 37.7508630900604 | -122.413563818716 | (37.7508630900604, -122.413563818716) | 2 | 4 | 7 | 28859 | 19 | |||
117701 | 34729 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3171 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38382 | 6008528.73936526 | 2101523.94206267 | 37.7508661360797 | -122.413341931038 | (37.7508661360797, -122.413341931038) | 2 | 4 | 7 | 28859 | 19 | ||
182567 | 34728 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3171 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38382 | 6008528.73936526 | 2101523.94206267 | 37.7508661360797 | -122.413341931038 | (37.7508661360797, -122.413341931038) | 2 | 4 | 7 | 28859 | 19 |
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) );